質問編集履歴

1

create文、insert文を追記しました。

2019/06/13 03:10

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -77,3 +77,47 @@
77
77
  |2019/09/01|2|B1店|2019/09/01|
78
78
 
79
79
  |2019/09/01|4|D1店|2019/09/01|
80
+
81
+
82
+
83
+ #create、insert文
84
+
85
+ ```sql
86
+
87
+ CREATE TABLE M_SHOP
88
+
89
+ (
90
+
91
+ SHOP_ID NUMBER(3,0) NOT NULL,
92
+
93
+ SHOP_NAME VARCHAR2(60) NOT NULL,
94
+
95
+ APLY_DATE VARCHAR2(8) NOT NULL
96
+
97
+ );
98
+
99
+
100
+
101
+
102
+
103
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (1,'A店','20190601');
104
+
105
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (2,'B店','20190601');
106
+
107
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (3,'C店','20190601');
108
+
109
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (1,'A1店','20190901');
110
+
111
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (2,'B1店','20190901');
112
+
113
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (4,'D1店','20190901');
114
+
115
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (1,'A2店','20191001');
116
+
117
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (2,'B2店','20191001');
118
+
119
+ insert into M_SHOP(SHOP_ID,SHOP_NAME,APLY_DATE) values (5,'E2店','20191001');
120
+
121
+
122
+
123
+ ```