SQL>
SQL> create table departments
2 ( deptno NUMBER(2)
3 , dname VARCHAR2(10)
4 , location VARCHAR2(20)
5 , mgr NUMBER(4)
6 ) ;
Table created.
SQL>
SQL> insert into departments values (10,'ACCOUNTING','NEW YORK' , 2);
1 row created.
SQL> insert into departments values (20,'TRAINING', 'VANCOUVER', 3);
1 row created.
SQL> insert into departments values (30,'SALES', 'CHICAGO', 4);
1 row created.
SQL> insert into departments values (40,'HR', 'BOSTON', 5);
1 row created.
SQL>
SQL> select dname
2 , substr(dname,4) as substr1
3 , substr(dname,4,3) as substr2
4 from departments;
DNAME SUBSTR1 SUBSTR2
---------- ------- -------
ACCOUNTING OUNTING OUN
TRAINING INING INI
SALES ES ES
HR
SQL>
SQL> drop table departments;
Table dropped.