"nocycle" - 1 õppematerjal

Andmebaaside programmeerimine

REGEXP_LIKE (kasutajatunnus,'^([[:alnum:]]{3,15})$')); ALTER TABLE t061859_menuu_rida ADD CONSTRAINT chk_hind CHECK (hind>0.00); ALTER TABLE t061859_tellimuse_rida ADD CONSTRAINT chk_kogus CHECK (kogus>0); 66  6.4Arvujada generaatorid CREATE SEQUENCE "TUD26"."T061859_SEQ_ISIK_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; CREATE SEQUENCE "TUD26"."T061859_SEQ_ISIK_LOG_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; CREATE SEQUENCE "TUD26"."T061859_SEQ_MENUU_GRUPP_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; CREATE SEQUENCE "TUD26"."T061859_SEQ_MENUU_RIDA_ID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; CREATE SEQUENCE "TUD26"