Home » SQL & PL/SQL » SQL & PL/SQL » Query everything, everywhere? (all rows, columns) (Oracle 10.x / SQL*PLUS)
Query everything, everywhere? (all rows, columns) [message #343593] Wed, 27 August 2008 10:51 Go to next message
JJVAC
Messages: 5
Registered: August 2008
Junior Member

Is there a query I could use to search through all of the cells within the database for a specific keyword? Something that might use LIKE '%keyword%'


Thanks,
Re: Query everything, everywhere? (all rows, columns) [message #343600 is a reply to message #343593] Wed, 27 August 2008 11:05 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above
Re: Query everything, everywhere? (all rows, columns) [message #343606 is a reply to message #343593] Wed, 27 August 2008 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is none.
But search on AskTom, this has been asked... and answered.

Regards
Michel
Re: Query everything, everywhere? (all rows, columns) [message #343691 is a reply to message #343606] Wed, 27 August 2008 17:29 Go to previous message
Barbara Boehmer
Messages: 8631
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5203164092530
Previous Topic: Procedure to calculate distance
Next Topic: ORA-14451 , creating index for a temporary table
Goto Forum:
  


Current Time: Mon Dec 05 12:58:24 CST 2016

Total time taken to generate the page: 0.09373 seconds