8. SQL Statements : DECLARE TABLE : DECLARE TABLE Example
 
Share this page                  
DECLARE TABLE Example
The following is a DECLARE TABLE statement example for a database table:
EXEC SQL DECLARE employee TABLE
       (eno    INTEGER2 NOT NULL,
       ename   CHAR(20) NOT NULL,
       age     INTEGER1,
       job     INTEGER2,
       sal     FLOAT4,
       dept    INTEGER2 NOT NULL);