Query all_source for certain string : all_source « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_source

SQL>
SQL>
SQL> COLUMN    text    FORMAT    a30 word_wrapped
SQL> SELECT    name, type, text
  2  FROM      all_source
  3  WHERE     UPPER(text) LIKE '%FREE BLOCKS%'
  4  and       rownum < 2;

NAME                   TYPE         TEXT
---------------------- ------------ ------------------------------
DBMS_SPACE             PACKAGE      --  Returns information about
                                    free blocks in an object
                                    (table, index,


SQL>