Query all_source : 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    a78
SQL> SELECT    text
  2  FROM      all_source
  3  WHERE     name = UPPER('&name')
  4  AND       type = UPPER('&type')
  5  and       rownum < 2
  6  AND       line BETWEEN &starting_line AND &ending_line;
Enter value for name:
old   3: WHERE     name = UPPER('&name')
new   3: WHERE     name = UPPER('')
Enter value for type: --