Int value column : Integer « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. Integer

Int value column

 
SQL>
SQL> create table t1
  2  (  x int primary key,
  3     y varchar2(25),
  4     z date
  5  )
  6  organization index;

Table created.

SQL>
SQL> drop table t1;

Table dropped.

SQL>
SQL>
SQL> --








Related examples in the same category

1.Use ANSI Data Types when creating a table
2.Define integer variables
3.Use for loop statement to set value to an integer variable