質問編集履歴

1

SQLをPL/SQL全体に修正

2017/05/19 02:21

投稿

R7038XX
R7038XX

スコア44

test CHANGED
File without changes
test CHANGED
@@ -16,29 +16,57 @@
16
16
 
17
17
  ###対象のSQL
18
18
 
19
- with
19
+ ```SQL
20
20
 
21
- w as
21
+ CREATE OR REPLACE PROCEDURE
22
22
 
23
- (
23
+ IS
24
24
 
25
- select a,b,c from d
25
+ :
26
26
 
27
- ),
27
+ BEGIN
28
28
 
29
- x as
29
+ with
30
30
 
31
- (
31
+ w as
32
32
 
33
- select a,b from w
33
+ (
34
34
 
35
- )
35
+ select a,b,c from d
36
36
 
37
- select *
37
+ ),
38
38
 
39
- from x
39
+ x as
40
40
 
41
+ (
42
+
43
+ select a,b from w
44
+
45
+ )
46
+
47
+ select *
48
+
49
+ bulk collect
50
+
51
+ into mWork
52
+
53
+ from x
54
+
41
- ;
55
+ ;
56
+
57
+ forall i in 1..mWork.count
58
+
59
+ insert into y
60
+
61
+ values mWork(i)
62
+
63
+ ;
64
+
65
+ END
66
+
67
+ /
68
+
69
+ ```
42
70
 
43
71
 
44
72