SQL: getting data for a null value column ??

From: baka <mesundara_at_hotmail.com>
Date: 2 Aug 2005 18:20:58 -0700
Message-ID: <1123032057.899519.70850@g47g2000cwa.googlegroups.com>

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)

the requirement is written in the follwoing way.

1. Create table tabA(Transaction table) create table tabA( bankcode varchar(10), bankname varchar2(15));
2. Create table tabB(Master table)

  create table tabB(

     bbankcode varchar(10),
     bbankname varchar(15));

3.Insert data into tabA(Transaction table)

insert into tabA(bankcode,bankname) values ('001','firstbank');
insert into tabA(bankcode,bankname) values ('002','secondbank');
insert into tabA(bankcode,bankname) values ('003','thirdbank');
insert into tabA(bankcode,bankname) values ('004','fourthbank');
insert into tabA(bankcode,bankname) values ('004','Firstunionbank');

4.Insert data into tabB(Master table)

insert into tabB(bbankcode,bbankname) values ('001','firstbank'); insert into tabB(bbankcode,bbankname) values ('003','thirdbank');

5.disply the current data from from tabA SQL> select * from tabA;

BANKCODE BANKNAME
-------------------- ------------------------------

001                  firstbank
002                  secondbank
003                  thirdbank
004                  fourthbank
004                  Firstunionbank

6.disply the current data from from tabB SQL> select * from tabB;

BBANKCODE BBANKNAME
-------------------- ------------------------------

001                  firstbank
003                  thirdbank

7.Disply data using join
SQL> select a.BANKCODE,b.BBANKNAME from tabA a,tabB b where a.BANKCODE=b.BBANKCODE(+);

BANKCODE BBANKNAME
-------------------- ------------------------------

001                  firstbank
002
003                  thirdbank

004
004

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

Received on Tue Aug 02 2005 - 20:20:58 CDT