OraFAQ Forum: SQL & PL/SQL » how to display the row number

Home » SQL & PL/SQL » SQL & PL/SQL » how to display the row number

Wed, 10 April 2002 00:03

R.SIVAKUMAR
Messages: 48
Registered: February 2002

Member

how to display the row number in sql out put

Wed, 10 April 2002 05:50

Phenoracle
Messages: 35
Registered: March 2001

Member

Quick answer is

Select empno, rownum
from emp
/

But is this really what you want, not sure.

Have Fun

Phenoracle

Wed, 10 April 2002 22:30

Alpesh Kothari
Messages: 7
Registered: April 2002

Junior Member

Use the rownum column in the SQL Query

Previous Topic:	ORA-01036: illegal variable name/number
Next Topic:	Import database from Oracle to SQL? Help!

Goto Forum:

]

Current Time: Tue Apr 23 02:36:27 CDT 2024