Re: ROWID + all other columns

In article 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
>
> -----------
> David Hiltz
> dhiltz_at_whsun1.wh.whoi.edu
> Network System Administrator
> Northeast Fisheries Science Center
> ######&_at_&######

No problem!!! Try:

SQL> select rowid, T.* from tablename T;

ROWID                       A B                                                 
------------------ ---------- ------------------------------                    
00001088.0000.0001          1 This is a test!                                   
00001088.0001.0001          5 This is a second test!                            
00001088.0002.0001          6 This is a third test!                             
00001088.0003.0001         21 Hardee Har Har                                    
 

It is similar to obtain all the columns from two (or more) tables:

SQL> select A.*, B.* from A, B;

Good luck!

Sincerely,

Martin Farber
Independent Oracle Consultant

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1D10
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216