Re: ROWID + all other columns
From: <mboxberg_at_ch2m.com>
Date: 28 Jun 1994 22:53:32 GMT
Message-ID: <2uq9ld$sud_at_ds9.ch2m.com>
Mark Boxberger
Data, Data, Data
CH2M HILL Inc. - Denver, CO USA
.............own opinions........not CH2M..........Blah Blah
AS NIXON SAID TO MITCHELL: "WE COULD DO IT, BUT IT WOULDN'T BE RIGHT" Received on Wed Jun 29 1994 - 00:53:32 CEST
Date: 28 Jun 1994 22:53:32 GMT
Message-ID: <2uq9ld$sud_at_ds9.ch2m.com>
In <Cs409E.71o_at_netnews.whoi.edu>, dhiltz_at_whsun1.wh.whoi.edu (David Hiltz) writes:
>
> Is there a way to query ROWID plus all other columns without explicitly
> mentioning all the column names, something liks...
>
> select rowid, * from tablename
>
> Thanks
>
Use an alias to identify the table:
select rowid, alias.* from tablename alias
Mark Boxberger
Data, Data, Data
CH2M HILL Inc. - Denver, CO USA
.............own opinions........not CH2M..........Blah Blah
AS NIXON SAID TO MITCHELL: "WE COULD DO IT, BUT IT WOULDN'T BE RIGHT" Received on Wed Jun 29 1994 - 00:53:32 CEST