Re: Select *, rowid ???

yogen_at_astro.ocis.temple.edu (Yogen Sanghani) wrote:
>Is there any way of selecting all the columns of a table plus the rowid
>without explicitly specifying the column names? Most of my processing
>happen in PL/SQL stored procedure, and I would like to keep the procedure
>loosely coupled with the table structure by not having to specify all
>the column names. But my processing would also benefit from using
>rowids as it is a two pass process. I tried using "Select *, rowid...."
>and "Select rowid, * ....", but neither worked. Any ideas?
>
>Oracle Server version 7.2.2...
>PL/SQL Version 2.2
>
>Any suggestions greatly appreciated.
>
>-----
>Yogen.

You can try something like this:
(for example using the table emp)

select b.rowid RID,a.* from emp a,emp b
where a.rowid=b.rowid

hope, this helps :-)
Martin Received on Tue Dec 19 1995 - 00:00:00 CET