回答編集履歴
3
訂正
answer
CHANGED
|
@@ -2,13 +2,13 @@
|
|
|
2
2
|
```SQL
|
|
3
3
|
SELECT 'NO DATA'
|
|
4
4
|
FROM (select NUll as dummy) DUAL
|
|
5
|
-
WHERE NOT
|
|
5
|
+
WHERE NOT EXISTS(～)
|
|
6
6
|
```
|
|
7
7
|
若しくはValuesで
|
|
8
8
|
```
|
|
9
9
|
SELECT 'NO DATA'
|
|
10
10
|
FROM (values(Null)) as DUAL(dummy)
|
|
11
|
-
WHERE NOT
|
|
11
|
+
WHERE NOT EXISTS(～)
|
|
12
12
|
```
|
|
13
13
|
いっそのこと、DUAL表を作る
|
|
14
14
|
```SQL
|
2
修正&追記
answer
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
全く同じ動作にするなら、疑似的な表をインラインビューで指定すればOK
|
|
2
2
|
```SQL
|
|
3
3
|
SELECT 'NO DATA'
|
|
4
|
-
FROM (select NUll) DUAL
|
|
4
|
+
FROM (select NUll as dummy) DUAL
|
|
5
5
|
WHERE NOT EXIST(～)
|
|
6
6
|
```
|
|
7
7
|
若しくはValuesで
|
|
@@ -9,4 +9,8 @@
|
|
|
9
9
|
SELECT 'NO DATA'
|
|
10
10
|
FROM (values(Null)) as DUAL(dummy)
|
|
11
11
|
WHERE NOT EXIST(～)
|
|
12
|
+
```
|
|
13
|
+
いっそのこと、DUAL表を作る
|
|
14
|
+
```SQL
|
|
15
|
+
select NUll as dummy into dual
|
|
12
16
|
```
|
1
追記
answer
CHANGED
|
@@ -1,6 +1,12 @@
|
|
|
1
1
|
全く同じ動作にするなら、疑似的な表をインラインビューで指定すればOK
|
|
2
2
|
```SQL
|
|
3
|
-
SELECT
|
|
3
|
+
SELECT 'NO DATA'
|
|
4
4
|
FROM (select NUll) DUAL
|
|
5
5
|
WHERE NOT EXIST(～)
|
|
6
|
+
```
|
|
7
|
+
若しくはValuesで
|
|
8
|
+
```
|
|
9
|
+
SELECT 'NO DATA'
|
|
10
|
+
FROM (values(Null)) as DUAL(dummy)
|
|
11
|
+
WHERE NOT EXIST(～)
|
|
6
12
|
```
|