用途:
ALTER TABLE EXTDL_REPORTSETS
MODIFY last_ASOFSTARTDATETIME DATE DEFAULT SYSDATE
我找不到10g
reference documentation - this is for 11g
.
如果要在create table语句中执行此操作:
CREATE TABLE "CDR"."EXTDL_REPORTSETS" (
"ID" NUMBER(38,0) NOT NULL ENABLE,
"SHORTNAME" VARCHAR2(255) NOT NULL ENABLE,
"DESCRIPTION" VARCHAR2(500) NOT NULL ENABLE,
"ASOFSTARTDATETIME" DATE DEFAULT SYSDATE NOT NULL ENABLE,
"ASOFENDDATETIME" DATE NOT NULL ENABLE,
CONSTRAINT "PK_EXTDL_REPORTSETS" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CDR_DATA" ENABLE
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE (
INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE "CDR_DATA" ;