Home » SQL & PL/SQL » SQL & PL/SQL » how to indentify the coloum
how to indentify the coloum [message #242627] Mon, 04 June 2007 07:08 Go to next message
Messages: 247
Registered: January 2007
Senior Member
i have 10000 tables is there. 
arround 5000 tables are  exiting same column like empno.

how to find out tables names


Re: how to indentify the coloum [message #242628 is a reply to message #242627] Mon, 04 June 2007 07:14 Go to previous message
Bill B
Messages: 1663
Registered: December 2004
Senior Member
select table_name,owner
from all_tab_columns
where column_name = 'EMPNO';
Previous Topic: invalid picture format when converting from sql7 to oracle9i
Next Topic: 2 CURSORS - access 1 cursor for processing???
Goto Forum:

Current Time: Mon Aug 21 20:53:58 CDT 2017

Total time taken to generate the page: 0.06248 seconds