If you want to search some words in the oracle database that you wrote before. You have two options to check out.
Firstly, we checks the ALL_SOURCES table.
SQL> Desc ALL_SOURCE
Name Type Nullable Default Comments
—– ————– ——– ——- ————————————————————————————————————-
OWNER VARCHAR2(30) Y Owner of the object
NAME VARCHAR2(30) Y Name of the object
TYPE VARCHAR2(12) Y Type of the object: “TYPE”, “TYPE BODY”, “PROCEDURE”, “FUNCTION”, “PACKAGE”, “PACKAGE BODY” or “JAVA SOURCE”
LINE NUMBER Y Line number of this line of source
TEXT VARCHAR2(4000) Y Source text
This table includes following types;
But, As you see “VIEWS..” are not in the list.!!! So we also check the ALL_VIEWS table.
We should check also ALL_TRIGGERS table 🙂