Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE "ZHW0FR"."TAG"
- (
- "TORZS_SZAM" NUMBER(5,0) NOT NULL ENABLE,
- "NEV" VARCHAR2(100 CHAR) NOT NULL ENABLE,
- "SZUL_DATUM" DATE NOT NULL ENABLE,
- "LAKCIM" VARCHAR2(100 CHAR) NOT NULL ENABLE,
- "TEL_SZAM" VARCHAR2(12 CHAR) NOT NULL ENABLE,
- "REG_DATUM" DATE DEFAULT SYSDATE NOT NULL ENABLE,
- "TAGSAG_LEJARAT" DATE NOT NULL ENABLE,
- CONSTRAINT "TAG_PK" PRIMARY KEY ("TORZS_SZAM") 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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "OKT" ENABLE,
- CONSTRAINT "TAG_CHK1" CHECK (TAGSAG_LEJARAT > REG_DATUM) 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 "OKT" ;
- CREATE OR REPLACE TRIGGER "ZHW0FR"."TAG_TRG" BEFORE
- INSERT ON TAG FOR EACH ROW BEGIN <<COLUMN_SEQUENCES>> BEGIN IF :NEW.TORZS_SZAM IS NULL THEN
- SELECT TAG_SEQ.NEXTVAL INTO :NEW.TORZS_SZAM FROM DUAL;
- END IF;
- END COLUMN_SEQUENCES;
- END;
- /
- ALTER TRIGGER "ZHW0FR"."TAG_TRG" ENABLE;
Add Comment
Please, Sign In to add comment