Mega Code Archive

Column format

SQL> SQL> create table courses 2 ( code VARCHAR2(6) constraint C_PK primary key 3 , description VARCHAR2(30) 4 , category CHAR(3) 5 , duration NUMBER(2) 6 ) ; Table created. SQL> insert into courses values('SQL','SQL','GEN',4); 1 row created. SQL> insert into courses values('OAU','Java','GEN',1); 1 row created. SQL> insert into courses values('JAV','C++','BLD',4); 1 row created. SQL> insert into courses values('PLS','C','BLD',1); 1 row created. SQL> insert into courses values('XML','XML','BLD',2); 1 row created. SQL> insert into courses values('ERM','ERP','DSG',3); 1 row created. SQL> insert into courses values('PMT','ERP','DSG',1); 1 row created. SQL> insert into courses values('RSD','jQuery','DSG',2); 1 row created. SQL> insert into courses values('PRO','Linux','DSG',5); 1 row created. SQL> insert into courses values('GEN','Oracle','DSG',4); 1 row created. SQL> SQL> SQL> select * from courses 2 where category = 'BLD'; CODE DESCRIPTION CAT DURATION ------ -------------------------- --- ---------- JAV C++ BLD 4 PLS C BLD 1 XML XML BLD 2 SQL> COL description FORMAT a26 SQL> / CODE DESCRIPTION CAT DURATION ------ -------------------------- --- ---------- JAV C++ BLD 4 PLS C BLD 1 XML XML BLD 2 SQL> SQL> drop table courses; Table dropped. SQL>