locked
How to find a specific record is in which table among multiple tables? RRS feed

  • Question

  • User2745213 posted

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

    Tuesday, January 8, 2013 3:18 AM

All replies

  • User-1699458064 posted

    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

    Tuesday, January 8, 2013 5:00 AM
  • User151468730 posted

    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,

    Thursday, January 10, 2013 11:05 PM
  • User2745213 posted

    Sorry Dude, it does not contain what i wanted....

    Friday, January 11, 2013 8:14 AM