TTitle ON and OFF : Ttitle BTitle « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. Ttitle BTitle

SQL>
SQL> SET PAGESIZE 66
SQL> COLUMN name FORMAT A30
SQL> COLUMN type FORMAT A15
SQL> COLUMN source_size FORMAT 999999
SQL> COLUMN parsed_size FORMAT 999999
SQL> COLUMN code_size FORMAT 999999
SQL> TTITLE 'Size of PL/SQL Objects > &&1 KBytes'
Enter value for 1:
SQL> SELECT name, type, source_size, parsed_size, code_size
  2    FROM user_object_size
  3   WHERE code_size > &&1 * 1000
  4   ORDER BY code_size DESC
  5  /
old   3:  WHERE code_size > &&1 * 1000
new   3:  WHERE code_size >  * 1000
 WHERE code_size >  * 1000
                    *
ERROR at line 3:
ORA-00936: missing expression


SQL>
SQL> TTITLE OFF
SQL>
SQL>
SQL>