Mega Code Archive

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>