Got a problem buddy.....
We dont know whether WEB_H or WEB_S will have more datas for the id of WEB. When the above code is executed, it works well for the id which has more number of datas in WEB_S. That is, im getting the actual result for the scenario i explained above..
If WEB_H has more datas.
For ex. Im changing the above scenario.
For id 14690001 from WEB, I get the data from WEB_H using...
kaviyarasan
Last Activity: Jul 20 '10, 01:43 PM
Joined: Jun 7 '10
Location:
-
Amazing amit..... very much thankyou... If possible prefer me some ways to excel in ORACLE....
Thanks for your great help.Leave a comment:
-
If you have any logic also, reply with that.Leave a comment:
-
How to add two result sets.
hi,
I have three tables named WEB, WEB_H, WEB_S. Fields in WEB are id and some other. Fields in WEB_H are id, h_id and some other. Fields in WEB_S are id, s_id and some other. In the three tables, id represent a same entity. WEB table is base table. For an id in WEB table, the matched datas may or may not be present in both, table WEB_S and WEB_H. But it is sure that atleast either of the two tables web_s or web_h has matched datas... -
kaviyarasan started a topic help me to get values of a table having only one column into one variablein Oraclehelp me to get values of a table having only one column into one variable
I have a table called COLUMN_VALUE which has only one column. Inside a procedure, I like to check whether chkmp(this is field name of other table) is equal to any of the values of column_value... help me
No activity results to display
Leave a comment: