Here Are the inputs of corresponding tables
SQL> select * from t1;
COL1 COL2
---------- ----------
1 -
2 -
- 55
3 11
4 -
5 66
6 rows selected.
SQL> select * from t2;
COL1 COL2
---------- ----------
8 -
- 33
- -
- 88
10 -
I Need A output like
COL1 COL2
1 11
2 33
3 55
4 66
5 88
8
10
Source Code :
CREATE TABLE T1
(
COL1 NUMBER,
COL2 NUMBER
);
CREATE TABLE T2
(
COL1 NUMBER,
COL2 NUMBER
);
Insert into T1
(COL1, COL2)
Values
(1, NULL);
Insert into T1
(COL1, COL2)
Values
(2, NULL);
Insert into T1
(COL1, COL2)
Values
(NULL, 55);
Insert into T1
(COL1, COL2)
Values
(3, 11);
Insert into T1
(COL1, COL2)
Values
(4, NULL);
Insert into T1
(COL1, COL2)
Values
(5, 66);
Insert into T2
(COL1, COL2)
Values
(8, NULL);
Insert into T2
(COL1, COL2)
Values
(NULL, 33);
Insert into T2
(COL1, COL2)
Values
(NULL, NULL);
Insert into T2
(COL1, COL2)
Values
(NULL, 88);
Insert into T2
(COL1, COL2)
Values
(10, NULL);
COMMIT;
TRY IT FRIENDZ....
--
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
