Disclaims:

Always study and research the information here first before use! UAYOR!

Create Table

Oracle® Database SQL Language Reference
11g Release 1 (11.1)

Part Number B28286-05


http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_7002.htm




CREATE TABLE USER.TABLE_NAME
(
RECORD_KEY NUMBER NOT NULL,
JOB_NO NUMBER NOT NULL,
USERNAME VARCHAR2(300 BYTE),
USER_ACTION VARCHAR2(100 BYTE),
ACTION_DATE DATE
)
TABLESPACE USER_TBL
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 1M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCACHE
NOPARALLEL;

  © Blogger template 'A Click Apart' by Ourblogtemplates.com 2008

Back to TOP