Re: SQLPLUS - Your Help reqrd.
From: <rtproffitt_at_my-deja.com>
Date: Fri, 03 Dec 1999 18:06:04 GMT
Message-ID: <8290q9$g1s$1_at_nnrp1.deja.com>
Date: Fri, 03 Dec 1999 18:06:04 GMT
Message-ID: <8290q9$g1s$1_at_nnrp1.deja.com>
Gokar,
I am not certain I understand your question:
If you are looking for names of columns, then you may search USER_, DBA_, ALL_TAB_COLUMNS. You could find all tables with a certain column name and/or type.
If you want to search for different names of columns which contain the very same data, you would use the same table, but the problem is much more difficult in scope. You would have to use that table to construct more queries to compare every column to every other column in every table (in theory)....(in practice, you might be able to narrow it down a bit).
Good luck
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 03 1999 - 19:06:04 CET