CREATE TABLE TABLENAMEEXAMLE(
PRIMARYKEYFILED NUMBER(2) [b]CONSTRAINT PK_ID PRIMARY KEY[/b],
NULLEXAMPLEFIELD VARCHAR2(8) [b]NOT NULL[/b],
FOREIGNKEYFIELD NUMBER(2) [b]CONSTRAINT FK_ID FOREIGN KEY(FOREIGNKEYFIELD) REFERENCES ANOTHERTABLE(PRIMARYKEYFIELDNAME),[/b]
FILEDUNIQUEEXAMPLEFIELD VARCHAR2(64) [b]UNIQUE[/b],
CHECKEXAMPLEFIELD NUMBER(7,2)[b] CONSTRAINT [/b]CONSTRAINTNAME [b]CHECK([/b]CHECKEXAMPLEFIELD>0 AND CHECKEXAMPLEFIELD<=3000)
}
PRIMARYKEYFILED NUMBER(2) [b]CONSTRAINT PK_ID PRIMARY KEY[/b],
NULLEXAMPLEFIELD VARCHAR2(8) [b]NOT NULL[/b],
FOREIGNKEYFIELD NUMBER(2) [b]CONSTRAINT FK_ID FOREIGN KEY(FOREIGNKEYFIELD) REFERENCES ANOTHERTABLE(PRIMARYKEYFIELDNAME),[/b]
FILEDUNIQUEEXAMPLEFIELD VARCHAR2(64) [b]UNIQUE[/b],
CHECKEXAMPLEFIELD NUMBER(7,2)[b] CONSTRAINT [/b]CONSTRAINTNAME [b]CHECK([/b]CHECKEXAMPLEFIELD>0 AND CHECKEXAMPLEFIELD<=3000)
}