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
pavuluri
Messages: 247
Registered: January 2007
Senior Member
hi,
i have 10000 tables is there. 
arround 5000 tables are  exiting same column like empno.

how to find out tables names


Thanks
srinivas


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: 1484
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: Wed Dec 07 05:15:04 CST 2016

Total time taken to generate the page: 0.14937 seconds