Search string around the Bank

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc

Poston Fri, 08 Oct 2004 11:30 am

Eae guys!
Following, is there any function of the Oracle to do a search for a particular string in all triggers, procedures, functions, views and tables?


Junior Chea
Júnior Cirqueira
Location: Sertãozinho - SP

Poston Fri, 08 Oct 2004 1:36 pm

Well, as far as I know, there's nothing ready to do this ...
But it's not very hard to assemble, because all this is recorded in the data dictionary tables.

Search on ALL_TRIGGERS, ALL_VIEWS what do you think the strings you're looking for.

To know what are all dictionary tables, see this topic: viewtopic.php?t=11 I hope I helped ...
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

  • See also
    Last Post

Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 6 guests