10 Replies Latest reply: Feb 28, 2014 3:15 PM by rp0428 RSS

    Updating a table

      Hi all,

       

      11.2.0.1

      aix6

       

      I am really confused when updating a table. I can not understand the logic how to do it

       

      Right now I want to update T1  (a1, b1, c1, d1 )  with  T2 (b2, c2, d2)

      As in:

       

      Update T1

      set a1='AIX'

      where b1=b2 and

      c1 between c2 and d2

      and d1='Oracle';

       

       

      Please help....

       

      Thanks Pk