Re: Select *, rowid ???

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 tablename.*, rowid
  from tablename
/

-- 
______________________
Robert C. nix_at_gate.net