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

baka wrote:
> Hello Oracle DBA's
>
> I need the output like step 8.
> What SQl statement is reqired without using any intemediate views..
> bla..bla
> i am execuiting one dynamic SQL in PL/SQL and this is my sample scripts
> for simplification
>
> (Please just scan the setps 1 to 8 to undestand my requirement)

[scanned :-)]

> 8.To get the below out put what SQL,I should write
>
> SQL>???????????????????????????????????????
> BANKCODE BBANKNAME
> -------------------- ------------------------------
> 001 firstbank
> 002 secondbank
> 003 thirdbank
> 004 fourthbank
> 004 Firstunionbank

Is this homework?

You should be able to do this easily by using the UNION and ORDER BY keywords.

HTH. Cheers,
Chris Val Received on Tue Aug 02 2005 - 20:48:03 CDT