Oracle in Qshow

[Ray Bailey]

As soon as I can get the access password from the customer / third party
I'll try out all of the suggestions given and let the list know the results.

Thanks again

Ray

		-----Original Message-----
		From:	Darren Reely [mailto:darren_reely@latticesemi.com]
		Sent:	19 April 2000 17:44
		To:	Ray Bailey
		Subject:	Re: Oracle in Qshow

		Ray,

		If I understand your request, your trying to find what
tables a column name
		is contained in.

		Is so, try the following.

		select owner, table_name, column_name, data_type,
data_length, nullable
		from all_tab_columns
		where column_name like UPPER('&input_column_name')
		/

		I also have another script like this that allows me to
search for two
		column names per table.

		Darren

		P.S.  Since none of your responder posted to the list,
please let us know
		your solution.
		
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.