Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query all_source for certain string

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>