Re: Select *, rowid ???

From: Thomas J Kyte <tkyte_at_us.oracle.com>
Date: 1995/12/15
Message-ID: <4as3j4$n45_at_inet-nntp-gw-1.us.oracle.com>#1/1


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.

select a.*, rowid from T a

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government Received on Fri Dec 15 1995 - 00:00:00 CET

Original text of this message