Hi All, I need to combine 2 queries given below. Please suggest.
Here is the details of table and its data: create table tab1 (col2 number, col3 number); create table tab2 (col1 number, col2 number, col3 number); insert into tab1 values(1, 233); insert into tab1 values(2, 23); insert into tab1 values(3, 23); insert into tab1 values(4, 256); insert into tab1 values(5, 130); insert into tab2 values(1234, 1, 5); insert into tab2 values(1536, 2, 3); insert into tab2 values(1536, 3, 7); insert into tab2 values(1234, 4, 5); insert into tab2 values(1234, 5, 7); ---------------------------------------------------------- How can I combine these 2 query? *Query 1* select tab1.col3 from tab1, tab2 where tab2.col1 <> 1234 and tab2.col2 = tab1.col2 and rownum = 1 order by tab2.col3 desc ; If no_data_found then Query 2. *Query 2* select tab1.col3 from tab1, tab2 where tab2.col1 = 1234 and tab2.col2 = tab1.col2 and rownum = 1 order by tab2.col3 ; If no_data_found then return NULL. Thanks G -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
