Column Format

SQL> column slcode format a10
SQL> select * from supplier;

CODE   SLNAME
-------- ------------
111       kkkkkkkkk
1          rrr
3          gggggggggggggggggg


SQL>
SQL> delete from supplier where length(code) <'3'
  2  /

2 rows deleted.

SQL> select * from supplier;

CODE   SLNAME
-------- ------------
111       kkkkkkkkk



SQL>