Disclaims:

Always study and research the information here first before use! UAYOR!
Showing posts with label Oracle Statement. Show all posts
Showing posts with label Oracle Statement. Show all posts

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