Home » RDBMS Server » Server Administration » Re: generating row number
Re: generating row number [message #373817] Mon, 14 May 2001 10:04
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
There is rownum in oracle, but they are assigned only after retrieving the result set of your query, just before display.

SQL> select rownum, empno, empname from emp;

if you want some thing like Identity in SQLserver
then there is rowid in oracle...
which is unique address for a row in a table.

So depending upon your requirement you can use
one of these two

Bala.

Report message to a moderator

Previous Topic: Re: generating row number
Next Topic: Re: sql help - I have a prob too
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 17:44:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.