Created
September 25, 2016 12:19
-
-
Save ntjn/e5a6b0ad3b084d01dcd9f4fcd5921250 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------------------------------------------------------- | |
-- File created - vasárnap-szeptember-25-2016 | |
-------------------------------------------------------- | |
-------------------------------------------------------- | |
-- DDL for Table DOLGOZO | |
-------------------------------------------------------- | |
CREATE TABLE "HADD7B"."DOLGOZO" | |
( "DKOD" NUMBER(4,0), | |
"DNEV" VARCHAR2(10 BYTE), | |
"FOGLALKOZAS" VARCHAR2(9 BYTE), | |
"FONOKE" NUMBER(4,0), | |
"BELEPES" DATE, | |
"FIZETES" NUMBER(7,2), | |
"JUTALEK" NUMBER(7,2), | |
"OAZON" NUMBER(2,0) | |
) 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 "USERS" ; | |
REM INSERTING into HADD7B.DOLGOZO | |
SET DEFINE OFF; | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7369','SMITH','CLERK','7902',to_date('80-DEC. -17','RR-MON-DD'),'800',null,'20'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7499','ALLEN','SALESMAN','7698',to_date('81-FEBR. -20','RR-MON-DD'),'1600','300','30'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7521','WARD','SALESMAN','7698',to_date('81-FEBR. -22','RR-MON-DD'),'1250','500','30'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7566','JONES','MANAGER','7839',to_date('81-ÁPR. -02','RR-MON-DD'),'2975',null,'20'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7654','MARTIN','SALESMAN','7698',to_date('81-SZEPT.-28','RR-MON-DD'),'1250','1400','30'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7698','BLAKE','MANAGER','7839',to_date('81-MÁJ. -01','RR-MON-DD'),'4250',null,'30'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7782','CLARK','MANAGER','7839',to_date('81-JÚN. -09','RR-MON-DD'),'2450','200','10'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7788','SCOTT','ANALYST','7566',to_date('82-DEC. -09','RR-MON-DD'),'3000',null,'20'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7839','KING','PRESIDENT',null,to_date('81-NOV. -17','RR-MON-DD'),'5000',null,'10'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7844','TURNER','SALESMAN','7698',to_date('81-SZEPT.-08','RR-MON-DD'),'1500','10','30'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7876','ADAMS','CLERK','7788',to_date('83-JAN. -12','RR-MON-DD'),'1100',null,'20'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7900','JAMES','CLERK','7698',to_date('81-DEC. -03','RR-MON-DD'),'950',null,'30'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7902','FORD','ANALYST','7566',to_date('81-DEC. -03','RR-MON-DD'),'3000','700','20'); | |
Insert into HADD7B.DOLGOZO (DKOD,DNEV,FOGLALKOZAS,FONOKE,BELEPES,FIZETES,JUTALEK,OAZON) values ('7934','MILLER','CLERK','7782',to_date('82-JAN. -23','RR-MON-DD'),'1300','600','10'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment