I want to do the following in coding:
There are two columns C1 and C2 in the following table VIJ.
I want do a select statement where i can select both the columns (c1 and C2) under 1 column (C1), but not update it in the column C1.
Select C1 from VIJ where C1 = (select column from C2);
Desired output: It must select all the columns from C1 and C2 under the column C1. But it must not get updated in the Table VIJ.
Only when i run the Select statement, i want it to select all values of C1 and C2 under the column C1.
How do i do this??
Oracle9i Enterprise Edition Release 18.104.22.168.0 - Production
Oracle Forms Builder 6i.
select c1 from vij
select c2 from vij
order by 1