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>
|