Selecting all but one column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Selecting all but one column

  1. #1
    Join Date
    Jan 2006
    Posts
    12

    Selecting all but one column

    Hi there all,

    Wondered if anyone knew of an easy way of selecting all but one column from a table without specifying each column individually? I've got a table with around 50 columns and i need to create several views which pick up 49 of the columns and leave 1 behind - i'm loathing the prospect of having to manually specifying every column apart from the one i don't want!

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Realistically, with a decent column-mode editor (Ultraedit on Windows, for example), this takes about 10 seconds per view.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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