Re: Select all cols in a table except for 2 explicitly specified cols without typing out the majority of the column names?

From: dana <>
Date: Thu, 23 Jul 2009 03:34:35 -0700 (PDT)
Message-ID: <>

Thanks Joel.

> Well, are you asking for a dynamic thing or an easy way to limit what
> other users see? If the latter, use views.

Not wanting to limit what others see. I need to limit columns for my own queries.

> If the former, either play around with ..._tab_cols for the report-generator kind of thing
> or keep a bunch of files around with all the columns in them and grab
> what you need in your editor for the real ad-hoc stuff.

Thanks for the suggestions. It's ad hoc plus from the way you're characterized ad hoc. I don't often know in advance what X number of columns I'll need to exclude; only know that I keep coming up against cases where I need most, but not all, of the columns in tables with a large number of columns.

I think I'll write some reusable PL/SQL that:

  1. Prompts for the number of columns to exclude
  2. Prompts for the column names to be excluded, looping the number of times specified in step 1.

If that's doable in PL/SQL. Or if someone already has this, please share. Or is an expert PL/SQL coder with some time to kill, please help. :-)


Dana Received on Thu Jul 23 2009 - 05:34:35 CDT

Original text of this message