...
| Info |
|---|
The DDL statements must be delimited by a forward slash (/) on its own line. |
| Info |
|---|
DDL index and constraint creation statements must reside outside of the table creation statement as seen below: CREATE TABLE DBTEST2.PROJECT_OBJECT_ATTRIBUTE_VAL ( PROJECT_OBJECT_ATTR_VAL_ID NUMBER(20, 0) NOT NULL , PROJECT_OBJECT_ATTR_ID NUMBER(20, 0) NOT NULL , SEQUENCE_NUMBER NUMBER(8, 0) NOT NULL , PROJECT_OBJECT_ATTR_VAL VARCHAR2(4000) NOT NULL , CREATED_ON TIMESTAMP NOT NULL , CREATED_BY VARCHAR2(128) NOT NULL , UPDATED_ON TIMESTAMP NOT NULL , UPDATED_BY VARCHAR2(128) NOT NULL , VERSION_NUMBER NUMBER(8, 0) , CONSTRAINT PROJECT_OBJECT_ATTR_VAL_PK PRIMARY KEY ( PROJECT_OBJECT_ATTR_VAL_ID ) ENABLE ); / CREATE UNIQUE INDEX DBTEST2.PROJECT_OBJECT_ATTR_PK ON DBTEST2.PROJECT_OBJECT_ATTRIBUTE (PROJECT_OBJECT_ATTR_ID ASC); |
...