1

Topic: Search of a line in meta data through SqlDeveloper.

Good afternoon.
Prompt what tool through Sql Developer in an Oracle DB I can find all procedures, triggers and other objects containing the line set by me (not the program code)?

2

Re: Search of a line in meta data through SqlDeveloper.

SELECT not to offer? smile

3

Re: Search of a line in meta data through SqlDeveloper.

View / Find DB Object

4

Re: Search of a line in meta data through SqlDeveloper.

Rostislavik;
ALL_SOURCE

5

Re: Search of a line in meta data through SqlDeveloper.

tru55;
How will write such  which to search not in the field of the table and in the trigger code, for example, or procedures?

6

Re: Search of a line in meta data through SqlDeveloper.

dba_source
dba_triggers
And you seriously suppose, what  uses something except requests?

7

Re: Search of a line in meta data through SqlDeveloper.

Before to write, it is necessary to esteem. To dock already specified.
[quote =] TEXT VARCHAR2 (4000) Text source of the stored object