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: 1629
Registered: December 2004
Senior Member
select table_name,owner
from all_tab_columns
where column_name = 'EMPNO';
Previous Topic: UTL_SMTP Package Body
Next Topic: 3 updates fail, 1 does not. Why?
Goto Forum:

Current Time: Mon Jun 26 20:46:48 CDT 2017

Total time taken to generate the page: 0.13156 seconds