回答編集履歴
1
備忘録SQL追記
test
CHANGED
|
@@ -1 +1,7 @@
|
|
|
1
1
|
decode使用で解決
|
|
2
|
+
|
|
3
|
+
select *
|
|
4
|
+
from table
|
|
5
|
+
where 1=1
|
|
6
|
+
and (no = DECODE (paramA, 'XXX', no, paramA))
|
|
7
|
+
;
|