set colsep : colsep « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. colsep

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>