| questions in using Toad [message #261366] |
Wed, 22 August 2007 07:06  |
beetel
Messages: 96
Registered: April 2007
|
Member |
|
|
hi,
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  |
ThomasG
Messages: 3212
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%';
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
