Home » SQL & PL/SQL » SQL & PL/SQL » SQL Qry
SQL Qry [message #192039] Sun, 10 September 2006 03:13 Go to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hi pals,

I need some help. Suppose there is one user account in my oracle database , i have some set of tables. I have a srch data .I need to check in which table the data is contained. Can anybody help me how to do that. do i need to write a stored procedure for this whick loops all tables thru "select tname from tab" using a curor or else is there any better way to do that.

Can anyone plz suggest me.

Thanks in advance,
Frank
Re: SQL Qry [message #192044 is a reply to message #192039] Sun, 10 September 2006 08:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Probably this is the Zillionth time i am asking this.
Please search the forum before posting.
These questions are asked many many times.
http://www.orafaq.com/forum/?SQ=0&t=search&srch=search+all+tables&btn_submit=Search&field=all&forum_limiter=& search_logic=AND&sort_order=DESC&author=+
Re: SQL Qry [message #192101 is a reply to message #192044] Sun, 10 September 2006 23:28 Go to previous message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Thank You Mahesh.
Previous Topic: Regarding Closing of a cursor.
Next Topic: Max Simultaneous Users
Goto Forum:
  


Current Time: Tue Dec 06 02:36:44 CST 2016

Total time taken to generate the page: 0.05520 seconds