call function from select join
-
Hi, This is quick question regarding calling function from join. In my project i am facing one situation where i need to use join between one temporary table and database table.From that join statement i need to call one function which taking 4 input parameters of temporary table and 4 input parameters of database table and returns one varchar2 value. Now here is question Let's say i creates one join statement like : "Select temp_table.firstname,temp_table.lastname,temp_table.ssn, db_table.firstname,db_table.lastname,db_table.ssn, getmatchtype(temp_table.firstname,.. ,..,..,..,db_table.firstname,..,..,..) from temporary_table ,database_table where ( /* some code in where clause which joins temporary table and database table. */ ) Now my question is that do my getmatchtype(temp_table.firstname,.. ,..,..,..,db_table.firstname,..,..,..) function returns same value for value based on input parameter or it returns different differnt value every time. Or can some one say me that how my function works in join query??? Actually , my requirement is that depends on where clause of join, function takes input parameters and return back to select query and everytime function should return new value for one by one record. Is this join works of not for that?? Can some body help me out for this?? Thankx. regards, montu3377
-
Hi, This is quick question regarding calling function from join. In my project i am facing one situation where i need to use join between one temporary table and database table.From that join statement i need to call one function which taking 4 input parameters of temporary table and 4 input parameters of database table and returns one varchar2 value. Now here is question Let's say i creates one join statement like : "Select temp_table.firstname,temp_table.lastname,temp_table.ssn, db_table.firstname,db_table.lastname,db_table.ssn, getmatchtype(temp_table.firstname,.. ,..,..,..,db_table.firstname,..,..,..) from temporary_table ,database_table where ( /* some code in where clause which joins temporary table and database table. */ ) Now my question is that do my getmatchtype(temp_table.firstname,.. ,..,..,..,db_table.firstname,..,..,..) function returns same value for value based on input parameter or it returns different differnt value every time. Or can some one say me that how my function works in join query??? Actually , my requirement is that depends on where clause of join, function takes input parameters and return back to select query and everytime function should return new value for one by one record. Is this join works of not for that?? Can some body help me out for this?? Thankx. regards, montu3377
My first idea would be to try it and see, but I think i see what you mean and your function should produce a different value based on the row, as long as the input parameters are different, of course...