Set column separation with colsep : Column « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. Column

Set column separation with colsep

    
SQL>
SQL> create table salary
  2  ( grade      NUMBER(2)   constraint S_PK primary key
  3  , lowerlimit NUMBER(6,2)
  4  , upperlimit NUMBER(6,2)
  5  , bonus      NUMBER(6,2)
  6  , constraint S_LO_UP_CHK check(lowerlimit <= upperlimit)
  7  ) ;

Table created.

SQL>
SQL> insert into salary values (1,  700,1200,   0);

1 row created.

SQL> insert into salary values (2, 1201,1400,  50);

1 row created.

SQL> insert into salary values (3, 1401,2000, 100);

1 row created.

SQL> insert into salary values (4, 2001,3000, 200);

1 row created.

SQL> insert into salary values (5, 3001,9999, 500);

1 row created.

SQL>
SQL> select * from salary;
[Enter]...

     GRADE LOWERLIMIT UPPERLIMIT    BONUS
---------- ---------- ---------- --------
         1        700       1200      .00
         2       1201       1400    50.00
         3       1401       2000   100.00
         4       2001       3000   200.00
         5       3001       9999   500.00

5 rows selected.

SQL> set colsep   " | "
SQL> set numwidth 10
SQL> /
[Enter]...

     GRADE | LOWERLIMIT | UPPERLIMIT |    BONUS
---------- | ---------- | ---------- | --------
         1 |        700 |       1200 |      .00
         2 |       1201 |       1400 |    50.00
         3 |       1401 |       2000 |   100.00
         4 |       2001 |       3000 |   200.00
         5 |       3001 |       9999 |   500.00

5 rows selected.

SQL> set colsep " "
SQL>
SQL> drop table salary;

Table dropped.

SQL>

   
    
    
    
  

Related examples in the same category