Re: Select *, rowid ???

From: Graeme Sargent <graeme_at_uk.pyramid.com>
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

Original text of this message