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>