Hi,
I need to determine if certain columns are in our data base tables. I
have been using the following script to determine if the columns exist
in the data base and in what table if they do. However, there are quite
a few columns to check. The code I have been using is as follows and I
have 384 columns left to check. Is there a simple way to put all of the
columns in the script without having to add 'or column_name = 'ect..'.
select column_name, table_name from all_tab_columns
where column_name = 'STATE';
I hope this makes sense.
Thanks for any help,
Eileen La Fond
Phone (206) 386-0011
e.mail Eileen.LaFond@xxxxxxxxxxx
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
