質問編集履歴
1
create文、insert文を追記しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -37,4 +37,26 @@
|
|
|
37
37
|
|2019/08/31|3|C店|2019/06/01|
|
|
38
38
|
|2019/09/01|1|A1店|2019/09/01|
|
|
39
39
|
|2019/09/01|2|B1店|2019/09/01|
|
|
40
|
-
|2019/09/01|4|D1店|2019/09/01|
|
|
40
|
+
|2019/09/01|4|D1店|2019/09/01|
|
|
41
|
+
|
|
42
|
+
#create、insert文
|
|
43
|
+
```sql
|
|
44
|
+
CREATE TABLE M_SHOP
|
|
45
|
+
(
|
|
46
|
+
SHOP_ID NUMBER(3,0) NOT NULL,
|
|
47
|
+
SHOP_NAME VARCHAR2(60) NOT NULL,
|
|
48
|
+
APLY_DATE VARCHAR2(8) NOT NULL
|
|
49
|
+
);
|
|
50
|
+
|
|
51
|
+
|
|
52
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (1,'A店','20190601');
|
|
53
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (2,'B店','20190601');
|
|
54
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (3,'C店','20190601');
|
|
55
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (1,'A1店','20190901');
|
|
56
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (2,'B1店','20190901');
|
|
57
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (4,'D1店','20190901');
|
|
58
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (1,'A2店','20191001');
|
|
59
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (2,'B2店','20191001');
|
|
60
|
+
insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (5,'E2店','20191001');
|
|
61
|
+
|
|
62
|
+
```
|