1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
CREATE TABLE "DOTNAV"."FONCTIONS_GENERIQUES"
( "IDFG" NUMBER(5,0) NOT NULL ENABLE,
"CODE_FONCTION" NUMBER(5,0),
"CODE_CONTRAT" VARCHAR2(3 BYTE),
"CODE_GENERIQUE" VARCHAR2(30 BYTE),
"QUANTITE" NUMBER(9,0),
"FREQUENCE" NUMBER(3,0),
"DATEDEB" NUMBER(12,0),
"DATEFIN" NUMBER(12,0),
"IDENTIFIANT" VARCHAR2(20 BYTE),
"DATE_MODIF" NUMBER(12,0),
CONSTRAINT "FONCTIONS_GENERIQUES_PK" PRIMARY KEY ("IDFG")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DOTNAV" ENABLE
) SEGMENT CREATION IMMEDIATE
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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DOTNAV" ;
CREATE OR REPLACE TRIGGER "DOTNAV"."INCREMENTFG"
before insert on FONCTIONS_GENERIQUES
for each row
begin
select SEQUENCEFG.nextval into :new.idfg from dual;
end;
/
ALTER TRIGGER "DOTNAV"."INCREMENTFG" ENABLE; |
Partager