1
Reply

How to display Row Number with Records in Oracle SQL Plus?

Deepak Verma

Deepak Verma

13y
5.6k
0
Reply

    To do so we need to use ROWNUM Pseudocolumn as follows :

    SELECT ROWNUM "S.N.", Column_name(s) FROM Table_name;