COLUMN x NEW_VALUE x

[William Robertson]

In SQL*Plus you can set a Define variable dynamically using COLUMN x NEW_VALUE x, then selecting a column named or aliased "X". I have a few handy scripts that I still have to open a SQL*Plus window for, e.g. cardinality.sql because this feature is not supported in the Command window.

Also the number formatting doesn't seem to work, e.g:

SQL> col a format 990

SQL> col a
column  a ON
format  990

SQL> select 12.345 as a from dual;

  A
---
12.
345

This breaks a couple more of my scripts, such as count.sql

 

[Marco Kalter]

The new_value option is indeed not yet supported. We'll look into the format bug.