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