Oracle PL/SQL Tutorial/SQL PLUS Session Environment/colsep
set colsep
<source lang="sql">
SQL> SQL> create table salgrades
2 ( grade NUMBER(2) 3 , lowerlimit NUMBER(6,2) 4 , upperlimit NUMBER(6,2) 5 , bonus NUMBER(6,2) 6 ) ;
Table created. SQL> SQL> SQL> insert into salgrades values (1, 700,1200, 0); 1 row created. SQL> insert into salgrades values (2, 1201,1400, 50); 1 row created. SQL> insert into salgrades values (3, 1401,2000, 100); 1 row created. SQL> insert into salgrades values (4, 2001,3000, 200); 1 row created. SQL> insert into salgrades values (5, 3001,9999, 500); 1 row created. SQL> SQL> select * from salgrades;
GRADE LOWERLIMIT UPPERLIMIT BONUS
---------- ---------- ------
1 700 1200 0 2 1201 1400 50 3 1401 2000 100 4 2001 3000 200 5 3001 9999 500
5 rows selected. SQL> SQL> SQL> SQL> SQL> set colsep " | " SQL> SQL> select * from salgrades;
GRADE | LOWERLIMIT | UPPERLIMIT | BONUS
| ---------- | ---------- | ------
1 | 700 | 1200 | 0 2 | 1201 | 1400 | 50 3 | 1401 | 2000 | 100 4 | 2001 | 3000 | 200 5 | 3001 | 9999 | 500
5 rows selected. SQL> SQL> set colsep " " SQL> SQL> drop table salgrades; Table dropped. SQL></source>