-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path222.sql
More file actions
164 lines (157 loc) · 10.5 KB
/
222.sql
File metadata and controls
164 lines (157 loc) · 10.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
--------------------------------------------------------
-- 파일이 생성됨 - 수요일-6월-29-2022
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table CATALOG_IMG
--------------------------------------------------------
CREATE TABLE "TEST1"."CATALOG_IMG"
( "PRODUCT_NUM" VARCHAR2(20 BYTE),
"IMG_NUM" NUMBER
) 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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table PRODUCT
--------------------------------------------------------
CREATE TABLE "TEST1"."PRODUCT"
( "PRODUCT_NUM" VARCHAR2(20 BYTE),
"PRODUCT_NAME" VARCHAR2(20 BYTE),
"PRICE" NUMBER,
"COUNT" NUMBER,
"P_CAT" VARCHAR2(20 BYTE)
) 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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table PRODUCT_OPTION
--------------------------------------------------------
CREATE TABLE "TEST1"."PRODUCT_OPTION"
( "PRICE_CHANGE" NUMBER DEFAULT 0,
"OPTION_NAME" VARCHAR2(20 BYTE),
"COUNT" NUMBER,
"PRODUCT_NUM" VARCHAR2(20 BYTE)
) 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 "SYSTEM" ;
REM INSERTING into TEST1.CATALOG_IMG
SET DEFINE OFF;
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',1);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',2);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',3);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',4);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',5);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',6);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',7);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',8);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',9);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',10);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',11);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',12);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',13);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',14);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',15);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',16);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',17);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',18);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',19);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',20);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',21);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',22);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',23);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',24);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10001',25);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',1);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',2);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',3);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',4);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',5);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',6);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',7);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',8);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',9);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',10);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',11);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',12);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',13);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10002',14);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',1);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',2);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',3);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',4);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',5);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',6);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',7);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',8);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',9);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',10);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',11);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',12);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',13);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',14);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',15);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',16);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',17);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',18);
Insert into TEST1.CATALOG_IMG (PRODUCT_NUM,IMG_NUM) values ('10003',19);
REM INSERTING into TEST1.PRODUCT
SET DEFINE OFF;
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10002','H310',319000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10001','M100',599000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10003','H300',499000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10004','더 이지',429000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10005','이지',459000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10006','디바S',399000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10007','디바',429000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10008','프라임',399000,100,'juice_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10009','TM-B21FWH',179900,100,'tea_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10010','TM-HB1FWH',199000,100,'tea_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10011','TM-MN1FWH',99000,100,'tea_maker');
Insert into TEST1.PRODUCT (PRODUCT_NUM,PRODUCT_NAME,PRICE,COUNT,P_CAT) values ('10012','TM-B01FWH',12400,100,'tea_maker');
REM INSERTING into TEST1.PRODUCT_OPTION
SET DEFINE OFF;
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'blue',100,'10002');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'pink',100,'10002');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'white',100,'10002');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'grey',100,'10001');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'black',100,'10003');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'ivory',100,'10003');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'red',100,'10003');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'silver',100,'10003');
Insert into TEST1.PRODUCT_OPTION (PRICE_CHANGE,OPTION_NAME,COUNT,PRODUCT_NUM) values (0,'white',100,'10003');
--------------------------------------------------------
-- DDL for Index SYS_C007323
--------------------------------------------------------
CREATE UNIQUE INDEX "TEST1"."SYS_C007323" ON "TEST1"."PRODUCT" ("PRODUCT_NUM")
PCTFREE 10 INITRANS 2 MAXTRANS 255
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 "SYSTEM" ;
--------------------------------------------------------
-- Constraints for Table CATALOG_IMG
--------------------------------------------------------
ALTER TABLE "TEST1"."CATALOG_IMG" MODIFY ("IMG_NUM" NOT NULL ENABLE);
ALTER TABLE "TEST1"."CATALOG_IMG" MODIFY ("PRODUCT_NUM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table PRODUCT
--------------------------------------------------------
ALTER TABLE "TEST1"."PRODUCT" ADD PRIMARY KEY ("PRODUCT_NUM")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
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 "SYSTEM" ENABLE;
ALTER TABLE "TEST1"."PRODUCT" MODIFY ("P_CAT" NOT NULL ENABLE);
ALTER TABLE "TEST1"."PRODUCT" MODIFY ("COUNT" NOT NULL ENABLE);
ALTER TABLE "TEST1"."PRODUCT" MODIFY ("PRICE" NOT NULL ENABLE);
ALTER TABLE "TEST1"."PRODUCT" MODIFY ("PRODUCT_NAME" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table PRODUCT_OPTION
--------------------------------------------------------
ALTER TABLE "TEST1"."PRODUCT_OPTION" MODIFY ("PRODUCT_NUM" NOT NULL ENABLE);
ALTER TABLE "TEST1"."PRODUCT_OPTION" MODIFY ("COUNT" NOT NULL ENABLE);
ALTER TABLE "TEST1"."PRODUCT_OPTION" MODIFY ("OPTION_NAME" NOT NULL ENABLE);