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

Thread: Selecting all but one column

  1. 02-06-2006, 07:32 AM #1
    Jukebox Timebom
    Jukebox Timebom is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  2. 02-06-2006, 10:00 AM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width