Re: SQL: getting data for a null value column ??

Hi

if you are on 9i then you cna try this.Or upgrade to 9i :-)

SQL> select a.BANKCODE,nvl(b.bbankname,a.bankname) from tabA a full outer join tabB b
on
a.BANKCODE=b.BBANKCODE;

BANKCODE NVL(B.BBANKNAME
---------- ---------------
003 thirdbank
001 firstbank
004 Firstunionbank
004 fourthbank
002 secondbank

regards
Hrishy Received on Thu Aug 04 2005 - 04:09:50 CDT