Re: ROWID + all other columns

From: Brian T. Walker <walkerb_at_bach.seattleu.edu>
Date: 28 Jun 1994 13:16:15 -0700
Message-ID: <2uq0ef$34t_at_bach.seattleu.edu>


David Hiltz <dhiltz_at_whsun1.wh.whoi.edu> wrote:

>

> Is there a way to query ROWID plus all other columns without explicitly
> mentioning all the column names, something liks...

Try using the following:

        select rowid, tablename.* from tablename;

It's real handy when you have a large number of columns and tables.... 8)

Brian Received on Tue Jun 28 1994 - 22:16:15 CEST

Original text of this message