Home » SQL & PL/SQL » Client Tools » questions in using Toad
questions in using Toad [message #261366] Wed, 22 August 2007 07:06 Go to next message
Messages: 96
Registered: April 2007

I apologize that this is an out-of-the-topic question, but I'm quite desperate for help. I'm new to Toad and could not quite see in their 'Help' how to do the following:
- search for a text in all the packages, procedures, functions, triggers etc.
- execute more than 1 SQL statement in the SQL editor.

Again, please excuse me for this question and I would really appreciate your instructions on how to do the above in Toad.
Re: questions in using Toad [message #261376 is a reply to message #261366] Wed, 22 August 2007 07:22 Go to previous messageGo to next message
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I don't know Toad, but all packages, procedures, functions, triggers etc are visible in the user_source view.

So you can get all lines which contain "yoursearch" for example with :

SELECT * FROM user_source WHERE lower(text) LIKE '%yoursearch%';

Re: questions in using Toad [message #261413 is a reply to message #261366] Wed, 22 August 2007 09:27 Go to previous message
Messages: 381
Registered: September 2006
Location: UK
Senior Member
To execute more than one command, use the "execute as script" button.

[Updated on: Wed, 22 August 2007 09:28]

Report message to a moderator

Previous Topic: Parametrizing entire sections of an sql script
Next Topic: Direct connection to DB from TOAD
Goto Forum:

Current Time: Wed Aug 05 20:45:16 CDT 2020