Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Mozi {
- MOZI_AZONOSITO VARCHAR2(10) DEFAULT ' ' NOT NULL,
- NEV VARCHAR2(40) DEFAULT ' ' NOT NULL,
- IRANYITOSZAM NUMBER(4) DEFAULT 0 NOT NULL,
- VAROS VARCHAR2(40) DEFAULT ' ' NOT NULL,
- UTCA VARCHAR2(40) DEFAULT ' ' NOT NULL,
- KARBANTARTO VARCHAR2(10) DEFAULT ' ' NOT NULL,
- KARBANTARTAS_DATUMA_ES_IDEJE DATE DEFAULT TO_DATE('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS') NOT NULL,
- };
- CREATE UNIQUE INDEX MOZI_AZONOSITO ON MOZI (MOZI_AZONOSITO);
- CREATE INDEX MOZI_NEV ON MOZI (NEV);
- DATABASENÉL:
- DBS: OMAGI
- USER: h661539
- PASS: -
- Magic DATA repositoryban DATABASE DEFAULT VALUE!!
- irányítószámnál range 1010-9999
- //**
- **//
Add Comment
Please, Sign In to add comment