質問編集履歴
2
コード修正とテーブル定義。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -12,7 +12,7 @@
|
|
|
12
12
|
|
|
13
13
|
|
|
14
14
|
|
|
15
|
-
vSquare tSquare
|
|
15
|
+
vSquare tSquare;
|
|
16
16
|
|
|
17
17
|
vSquare(0)(0) := 0;
|
|
18
18
|
|
|
@@ -44,13 +44,45 @@
|
|
|
44
44
|
|
|
45
45
|
|
|
46
46
|
|
|
47
|
-
vSquare tSquare
|
|
47
|
+
vSquare tSquare;
|
|
48
48
|
|
|
49
49
|
vSquare(0)(0) := 1000;
|
|
50
50
|
|
|
51
51
|
vSquare(0)(1) := 'ABC';
|
|
52
52
|
|
|
53
53
|
...
|
|
54
|
+
|
|
55
|
+
```
|
|
56
|
+
|
|
57
|
+
|
|
58
|
+
|
|
59
|
+
```TABLE
|
|
60
|
+
|
|
61
|
+
CREATE TABLE MY_TABLE_A (
|
|
62
|
+
|
|
63
|
+
num NUMBER(5) NOT NULL,
|
|
64
|
+
|
|
65
|
+
name VARCHAR2(15) NOT NULL,
|
|
66
|
+
|
|
67
|
+
score1 NUMBER(10) NOT NULL,
|
|
68
|
+
|
|
69
|
+
score2 NUMBER(10) NOT NULL,
|
|
70
|
+
|
|
71
|
+
score3 NUMBER(10) NOT NULL,
|
|
72
|
+
|
|
73
|
+
score4 NUMBER(10) NOT NULL,
|
|
74
|
+
|
|
75
|
+
score5 NUMBER(10) NOT NULL,
|
|
76
|
+
|
|
77
|
+
score6 NUMBER(10) NOT NULL,
|
|
78
|
+
|
|
79
|
+
score7 NUMBER(10) NOT NULL,
|
|
80
|
+
|
|
81
|
+
score8 NUMBER(10) NOT NULL,
|
|
82
|
+
|
|
83
|
+
score9 NUMBER(10) NOT NULL
|
|
84
|
+
|
|
85
|
+
);
|
|
54
86
|
|
|
55
87
|
```
|
|
56
88
|
|
|
@@ -66,7 +98,7 @@
|
|
|
66
98
|
|
|
67
99
|
```PL/SQL
|
|
68
100
|
|
|
69
|
-
IF vSquare(0)(10) = 0 THEN
|
|
101
|
+
IF vSquare(0)(10) = 0 THEN /* ここで型エラー TO_CHAR(0)でも同様 */
|
|
70
102
|
|
|
71
103
|
/* 処理 */
|
|
72
104
|
|
1
見出しとリンクの修正
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
|
|
1
|
+
PL/SQLの2次元配列の作り方について
|
test
CHANGED
|
@@ -1,4 +1,4 @@
|
|
|
1
|
-
|
|
1
|
+
PL/SQL で、テーブルの型に合わせた２次元配列を作りたいのですが、
|
|
2
2
|
|
|
3
3
|
|
|
4
4
|
|
|
@@ -24,7 +24,9 @@
|
|
|
24
24
|
|
|
25
25
|
```
|
|
26
26
|
|
|
27
|
-
出典
|
|
27
|
+
[出典https://www.shift-the-oracle.com/plsql/collection/multi-dimension-array.html](https://www.shift-the-oracle.com/plsql/collection/multi-dimension-array.html)
|
|
28
|
+
|
|
29
|
+
|
|
28
30
|
|
|
29
31
|
|
|
30
32
|
|