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>
> Is there a way to query ROWID plus all other columns without explicitly
> mentioning all the column names, something liks...
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