I have sql query as below
select header_id,order_number from oe_order_headers_all.
and data it is displaying as
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.
You can just use ROWNUM Pseudocolumn
select rownum id, header_id,order_number from oe_order_headers_all
thanks its working