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?

Report message to a moderator

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: 21825
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.

Report message to a moderator

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: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Common name or common values or common types or common what?

Regards
Michel

Report message to a moderator

Re: common column [message #401073 is a reply to message #401061] Fri, 01 May 2009 07:52 Go to previous message
joy_division
Messages: 4963
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;

Report message to a moderator

Previous Topic: SQL Select Query
Next Topic: Inserting data with &
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 17 00:56:13 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.