Guest User

Untitled

a guest
Sep 14th, 2017
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.65 KB | None | 0 0
  1. CREATE TABLE Mozi {
  2.     MOZI_AZONOSITO VARCHAR2(10) DEFAULT ' ' NOT NULL,
  3.     NEV VARCHAR2(40) DEFAULT ' ' NOT NULL,
  4.     IRANYITOSZAM NUMBER(4) DEFAULT 0 NOT NULL,
  5.     VAROS VARCHAR2(40) DEFAULT ' ' NOT NULL,
  6.     UTCA VARCHAR2(40) DEFAULT ' ' NOT NULL,
  7.     KARBANTARTO VARCHAR2(10) DEFAULT ' ' NOT NULL,
  8.     KARBANTARTAS_DATUMA_ES_IDEJE DATE DEFAULT TO_DATE('0001/01/01 00:00:00', 'YYYY/MM/DD HH24:MI:SS') NOT NULL,
  9.  
  10. };
  11. CREATE UNIQUE INDEX MOZI_AZONOSITO ON MOZI (MOZI_AZONOSITO);
  12. CREATE INDEX MOZI_NEV ON MOZI (NEV);
  13.  
  14. DATABASENÉL:
  15. DBS: OMAGI
  16. USER: h661539
  17. PASS: -
  18. Magic DATA repositoryban DATABASE DEFAULT VALUE!!
  19. irányítószámnál range 1010-9999
  20.  
  21.  
  22. //**
  23.  
  24. **//
Add Comment
Please, Sign In to add comment