Difference between revisions of "CREATE a new table"

Latest revision as of 09:42, 16 July 2012

CREATE a new table

schema:scott

The following are examples of field types:

DROP TABLE t_test

CREATE TABLE t_test
 (a INTEGER NOT NULL PRIMARY KEY
 ,b VARCHAR(10)
 )

CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR2(10)
 )

CREATE TABLE t_test
 (a INTEGER PRIMARY KEY
 ,b VARCHAR(10)
 )

CREATE a new table

DROP a table

@@ Line 1: / Line 1: @@
 CREATE a new table
 <div class='ht'>
-<div class=params>schema:gisq</div>
+<div class=params>schema:scott</div>
 <div>
 The following are examples of field types:

MEMO	Allows up to 65535 characters
CURRENCY	Suitable for money.

CLOB	Allows large character fields.
NUMBER(10,2)	Up to 10 digits before the point, 2 after.

TEXT	Allows up to 65535 characters
DECIMAL(10,2)	Up to 10 digits before the point, 2 after.