Home » SQL & PL/SQL » SQL & PL/SQL » Find the text in entire database (10 g)
Find the text in entire database [message #388474] Wed, 25 February 2009 00:27 Go to next message
McLan
Messages: 36
Registered: April 2008
Member
Quote:
I have a database with 200 tables, I would like to know the column and table name in which the text 'mydatabase' is stored in entire database schema.

How does it possible to find out matching text in entire database?

Regards,
Re: Find the text in entire database [message #388478 is a reply to message #388474] Wed, 25 February 2009 00:32 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
With much expenditure of time & CPU cycles!
Re: Find the text in entire database [message #388480 is a reply to message #388474] Wed, 25 February 2009 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search on AskTom for "find_string" function.

Regards
Michel
Re: Find the text in entire database [message #388660 is a reply to message #388474] Wed, 25 February 2009 20:58 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
then after you search ask tom, you might wish to make this a learning opportunity for yourself and do some reading about dynamic sql.

dbms_sql

execute immediate


Good luck, Kevin
Previous Topic: Get_Hash_Value_collisions (merged)
Next Topic: Running a batch file from oracle
Goto Forum:
  


Current Time: Thu Dec 08 18:10:48 CST 2016

Total time taken to generate the page: 0.12645 seconds