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