Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE ZATRUDNIENI4(
- Z_ID NUMBER(6) CONSTRAINT Z_PK PRIMARY KEY,
- Nazwisko VARCHAR2(12) CONSTRAINT Z_naz NOT NULL,
- Imie VARCHAR2(12) CONSTRAINT Z_imie NOT NULL,
- Start_date DATE CONSTRAINT Z_data NOT NULL
- CONSTRAINT Z_data_2 CHECK (Start_date>TO_DATE('01/01/2006','DD/MM/YYYY')),
- Pensja NUMBER(8,2) CONSTRAINT Z_pensja NOT NULL
- CONSTRAINT Z_pensja_2 CHECK (pensja <5500))
- STORAGE(
- INITIAL 40665088
- NEXT 819200
- PCTINCREASE 0
- MAXEXTENTS UNLIMITED)
- PCTFREE 20
- PCTUSED 60
- INITRANS 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement