CREATE TABLE

The SQL CREATE TABLE statement is used to

The general format is:

CREATE [GLOBAL TEMPORARY] TABLE [schema.]table
column datatype [DEFAULT expr] [column_constraint(s)]
[,column datatype [,...]]
table_constraint
table_ref_constraint
[ON COMMIT {DELETE|PRESERVE} ROWS]
storage_options [COMPRESS int|NOCOMPRESS]
[LOB_storage_clause][varray_clause][nested_storage_clause] [XML_type_clause]
Partitioning_clause
[[NO]CACHE] [[NO]ROWDEPENDENCIES] [[NO]MONITORING] [PARALLEL parallel_clause]
[ENABLE enable_clause | DISABLE disable_clause]
{ENABLE|DISABLE} ROW MOVEMENT
[AS subquery]

Example 1:

CREATE TABLE invoice (
numinvoice number,
desinvoice varchar2(10)
)

Example 2:

CREATE TABLE invoice
(
numinvoice number,
desinvoice varchar2(10)
)
TABLESPACE example
STORAGE
(
INITIAL 200K
NEXT 200K
MINEXTENTS 1
MAXEXTENTS 512
);