Select *, rowid ???
From: Yogen Sanghani <yogen_at_astro.ocis.temple.edu>
Date: 1995/12/15
Message-ID: <4aqtpu$ivk_at_cronkite.ocis.temple.edu>#1/1
Yogen. Received on Fri Dec 15 1995 - 00:00:00 CET
Date: 1995/12/15
Message-ID: <4aqtpu$ivk_at_cronkite.ocis.temple.edu>#1/1
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. Received on Fri Dec 15 1995 - 00:00:00 CET