How to display Row Number with Records in Oracle SQL Plus?
Deepak Verma
To do so we need to use ROWNUM Pseudocolumn as follows :SELECT ROWNUM "S.N.", Column_name(s) FROM Table_name;