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>