Use ANSI Data Types when creating a table : Integer « Data Type « Oracle PL / SQL






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

Use ANSI Data Types when creating a table

 
SQL>
SQL> create table foo (
  2         a   integer,
  3         b   dec( 9, 2 ),
  4         c   character varying( 30 ),
  5         d   national char( 3 )
  6      );

Table created.


SQL>
SQL> drop table foo;

Table dropped.

SQL>








Related examples in the same category

1.Define integer variables
2.Int value column
3.Use for loop statement to set value to an integer variable