column format: ascii type, 26 letter long : Column « SQL Plus « Oracle PL / SQL

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

column format: ascii type, 26 letter long

    
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>

   
    
    
    
  

Related examples in the same category