Home » RDBMS Server » Server Administration » Re: generating row number
Re: generating row number [message #373816] Mon, 14 May 2001 09:59
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: how to insert gif image into table?
Next Topic: Re: generating row number
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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