Home » SQL & PL/SQL » SQL & PL/SQL » common column (ORCCLE 9I)
common column [message #401061] Fri, 01 May 2009 06:13 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
How can we find the comom column in ten tables?
Re: common column [message #401062 is a reply to message #401061] Fri, 01 May 2009 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One way would be to intersect results of queries that select column name from USER_TAB_COLUMNS for all tables you are interested in.
Re: common column [message #401069 is a reply to message #401061] Fri, 01 May 2009 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Common name or common values or common types or common what?

Regards
Michel
Re: common column [message #401073 is a reply to message #401061] Fri, 01 May 2009 07:52 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
select common from table1
union all
select common from table2
union all
.
.
.
select common from table10;
Previous Topic: SQL Select Query
Next Topic: Inserting data with &
Goto Forum:
  


Current Time: Thu Dec 08 08:12:10 CST 2016

Total time taken to generate the page: 0.08597 seconds