Thursday, February 23, 2017

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>

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...