Re: Select all cols in a table except for 2 explicitly specified cols without typing out the majority of the column names?
Date: Thu, 23 Jul 2009 03:34:35 -0700 (PDT)
Message-ID: <4d755ace-374f-40d7-8494-ad34f6474479_at_c2g2000yqi.googlegroups.com>
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:
- Prompts for the number of columns to exclude
- 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. :-)
Thanks.
Dana Received on Thu Jul 23 2009 - 05:34:35 CDT