DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: rowid select all

Hybrid View

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    rowid select all

    Hi Friends,

    I want to spool my table to text format and i want to include
    the rowid. I have also long list of columns in this table.
    Is there a short-way to select all columns in a table + rowid?
    Like >> select *,rowid from table_a;


    Thanks a lot

  2. #2
    Join Date
    Sep 2005
    Posts
    278
    select a.*,rowid from table_a a;

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width