Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help in writing an sql
One way would be to do a full outer join, on tab1 where X with tab1
where Y (joining the table with itself). You would then need to use the
nvl function in the decode statement.
Received on Wed Feb 02 2005 - 07:40:12 CST