Re: Select *, rowid ???
Date: 1996/01/04
Message-ID: <graeme-0401961424250001_at_grsmac.uk.pyramid.com>#1/1
In article <4b6812$n53_at_inet-nntp-gw-1.us.oracle.com>, Martin Paul <mpaul_at_de.oracle.com> wrote:
> 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
Much better would be:
select rowid, emp.* from emp;
graeme
-- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd or Pyramid Technology Inc --------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44(0)1252 373035 ---mmm----- Senior Database Consultant Fax : +44(0)1252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme_at_pyra.co.uk --------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.Received on Thu Jan 04 1996 - 00:00:00 CET