CREATE TABLE |
Créer une table |
|---|---|
| Oracle Database SQL |
Syntaxe
|
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] [ PCTFREE int PCTUSED int INITTRANS int MAXTRANS int STORAGE storage_clause TABLESPACE tablespace [LOGGING|NOLOGGING] ] [COMPRESS int|NOCOMPRESS] [LOB_storage_clause][varray_clause][ NESTED TABLE {nested_item | COLUMN_VALUE} [ [ELEMENT] IS OF TYPE (ONLY type) ]] | [ [NOT] SUBSTITUTABLE AT ALL LEVELS ]] STORE AS storage_table [RETURN AS {LOCATOR|VALUE} ] ] [ [XMLTYPE [COLUMN] column [STORE AS OBJECT RELATIONAL] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Segname (LOB_Params)]] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Params] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] ] Partitioning_clause [[NO]CACHE] [[NO]ROWDEPENDENCIES] [[NO]MONITORING] [PARALLEL parallel_clause] [ENABLE enable_clause | DISABLE disable_clause] {ENABLE|DISABLE} ROW MOVEMENT [AS subquery] |
|
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] CLUSTER cluster_name (col1, col2,... ) [LOB_storage_clause][varray_clause][ NESTED TABLE {nested_item | COLUMN_VALUE} [ [ELEMENT] IS OF TYPE (ONLY type) ]] | [ [NOT] SUBSTITUTABLE AT ALL LEVELS ]] STORE AS storage_table [RETURN AS {LOCATOR|VALUE} ] ] [ [XMLTYPE [COLUMN] column [STORE AS OBJECT RELATIONAL] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Segname (LOB_Params)]] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Params] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] ] Partitioning_clause [[NO]CACHE] [[NO]ROWDEPENDENCIES] [[NO]MONITORING] [PARALLEL parallel_clause] [ENABLE enable_clause | DISABLE disable_clause] {ENABLE|DISABLE} ROW MOVEMENT [AS subquery] |
|
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] ORGANIZATION {HEAP [ PCTFREE int PCTUSED int INITTRANS int MAXTRANS int STORAGE storage_clause TABLESPACE tablespace [LOGGING|NOLOGGING] ] [COMPRESS int|NOCOMPRESS] | INDEX [ storage_option(s) {MAPPING TABLE | NOMAPPING} [PCTTHRESHOLD int] [COMPRESS int|NOCOMPRESS] [ [INCLUDING column_name] OVERFLOW [storage_option(s)] ] ] | EXTERNAL ( [TYPE access_driver_type] DEFAULT DIRECTORY directory [ACCESS PARAMETERS {USING CLOB subquery | (opaque_format_spec) }] LOCATION (directory:'location_specifier' [,directory2:'location_specifier2'...) ) [REJECT LIMIT {int|UNLIMITED}] } [LOB_storage_clause][varray_clause][ NESTED TABLE {nested_item | COLUMN_VALUE} [ [ELEMENT] IS OF TYPE (ONLY type) ]] | [ [NOT] SUBSTITUTABLE AT ALL LEVELS ]] STORE AS storage_table [RETURN AS {LOCATOR|VALUE} ] ] [ [XMLTYPE [COLUMN] column [STORE AS OBJECT RELATIONAL] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Segname (LOB_Params)]] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Params] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] ] Partitioning_clause [[NO]CACHE] [[NO]ROWDEPENDENCIES] [[NO]MONITORING] [PARALLEL parallel_clause] [ENABLE enable_clause | DISABLE disable_clause] {ENABLE|DISABLE} ROW MOVEMENT [AS subquery] |
|
CREATE TABLE [schema.]table OF XMLTYPE [ [XMLTYPE [COLUMN] column [STORE AS OBJECT RELATIONAL] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Segname (LOB_Params)]] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] [XMLTYPE [COLUMN] column [STORE AS CLOB LOB_Params] ] [[XMLSCHEMA xmlschema_URL] ELEMENT {element |xmlschema_URL#element}] ] |
Description
Cette instruction permet de créer une table dans la base de données spécifié ou courante.
Voir également
Article - Les géants de l'informatique - Oracle
Dernière mise à jour : Lundi, le 11 mai 2015