Re: Select *, rowid ???

In article <4aqtpu$ivk_at_cronkite.ocis.temple.edu>, yogen_at_astro.ocis.temple.edu (Yogen Sanghani) says:
>
>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.

Hi,

You should try :

  select mytable.*, rowid from mytable;

or

  select t.*, rowid from mytable t;

Eric Received on Fri Dec 15 1995 - 00:00:00 CET