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: 21127
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: 65084
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: 4758
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: Sat Jul 22 13:54:35 CDT 2017

Total time taken to generate the page: 1.08008 seconds