1 Reply Latest reply on Dec 7, 2013 12:32 PM by Priyasagi

    Select all the values of column1 and column2 under column1 without updating it.

    Vijetha

      Hi all,

       

      I want to do the following in coding:

       

      There are two columns C1 and C2 in the following table VIJ.

      TABLE:VIJ.

       

      C1C2
      10011005
      10071009
      10291038
      10751056
      10971076

       

      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 9.2.0.1.0 - Production

      Oracle Forms Builder 6i.


      Thank You.