Consider in oracle server i have 10 tables which contains number of records in it.My query is I want a command to find out the "Sam" record is available in which table among multiple tables?
If there is any query to get it,please let me know....
With regards to your request, in your oracle server, if you have 10 tables which contains number of records in it - and you want a command to find out if a specific record is available among the multiple tables, please view the following: It contains steps
that could help you correct the issue you are currently facing.
niranjan479
Member
34 Points
75 Posts
How to find a specific record is in which table among multiple tables?
Jan 08, 2013 07:18 AM|LINK
Hello everybody,
Consider in oracle server i have 10 tables which contains number of records in it.My query is I want a command to find out the "Sam" record is available in which table among multiple tables?
If there is any query to get it,please let me know....
Thank you..
KanwalH
Member
98 Points
19 Posts
Re: How to find a specific record is in which table among multiple tables?
Jan 08, 2013 09:00 AM|LINK
Hi,
Not sure if there is any direct way, but here is a work-around.
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
He has implemented a custom SP that reaches out for all the tables and performs the search.
Thanks
Kanwal
____________________________________________
Please "Mark as Answer", if it helps you
april_123456
Participant
775 Points
246 Posts
Re: How to find a specific record is in which table among multiple tables?
Jan 11, 2013 03:05 AM|LINK
Hello Niran Jan,
With regards to your request, in your oracle server, if you have 10 tables which contains number of records in it - and you want a command to find out if a specific record is available among the multiple tables, please view the following: It contains steps that could help you correct the issue you are currently facing.
http://etutorials.org/SQL/MySQL/Part+I+General+MySQL+Use/Chapter+3.+MySQL+SQL+Syntax+and+Use/Retrieving+Records+from+Multiple+Tables/
Best of Luck!
With Kind Regards,
niranjan479
Member
34 Points
75 Posts
Re: How to find a specific record is in which table among multiple tables?
Jan 11, 2013 12:14 PM|LINK
Sorry Dude, it does not contain what i wanted....