CREATE TABLE DG_1
(
DG_NUMBER1 NUMBER,
DG_CHAR1 VARCHAR2(10 BYTE),
DG_NUMBER2 NUMBER,
DG_CHAR2 VARCHAR2(10 BYTE)
)
TABLESPACE USERS
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
-----
So we have first table ready DG_1 with four columns. The table does not has any value , and can be altered as desired.
Table can be made and data insertesd with different IDE available
Sunday, March 16, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment