2 Replies Latest reply: Sep 10, 2013 7:10 AM by user13424229 RSS

    Need to get sequence value in another column in oracle

    user13424229

      Hi ALL,

       

      I have sql query as below

       

      select header_id,order_number from oe_order_headers_all.

       

      and data it is displaying as

       

      heder_id     order_number

      111            500001

      121            500400

       

      I need to display  another field with some sequence value like as below

       

      id     heder_id     order_number

      1      111                    500001

      2      121                    500400

       

      so how to get sequence value in another column please help me on this.

       

      Thnaks