MySQL Forums
Forum List  »  Oracle

Re: Oracle rowid column = mysql ??
Posted by: philippe granger
Date: September 14, 2007 08:22AM

Its possible to have the row id by using var like that

set @a := 0;
select *, @a := @a+1 as rowid
from table
limit 10 ;

Options: ReplyQuote


Subject
Views
Written By
Posted
52017
May 11, 2005 12:17PM
25039
May 25, 2005 12:19AM
18018
August 12, 2005 06:22PM
Re: Oracle rowid column = mysql ??
16294
September 14, 2007 08:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.