回答編集履歴
3
追記
test
CHANGED
|
@@ -11,3 +11,15 @@
|
|
|
11
11
|
select '+' || to_char(age, 'FM00')
|
|
12
12
|
|
|
13
13
|
```
|
|
14
|
+
|
|
15
|
+
追記
|
|
16
|
+
|
|
17
|
+
--
|
|
18
|
+
|
|
19
|
+
文字型で空文字もNullと同義に扱うなら
|
|
20
|
+
|
|
21
|
+
```SQL
|
|
22
|
+
|
|
23
|
+
select case when age is null or age='' then age else '+' || age end
|
|
24
|
+
|
|
25
|
+
```
|
2
訂正
test
CHANGED
|
@@ -11,11 +11,3 @@
|
|
|
11
11
|
select '+' || to_char(age, 'FM00')
|
|
12
12
|
|
|
13
13
|
```
|
|
14
|
-
|
|
15
|
-
若しくは直接フォーマットしてしまうとか
|
|
16
|
-
|
|
17
|
-
```SQL
|
|
18
|
-
|
|
19
|
-
select to_char(age, '+FM00')
|
|
20
|
-
|
|
21
|
-
```
|
1
追記
test
CHANGED
|
@@ -11,3 +11,11 @@
|
|
|
11
11
|
select '+' || to_char(age, 'FM00')
|
|
12
12
|
|
|
13
13
|
```
|
|
14
|
+
|
|
15
|
+
若しくは直接フォーマットしてしまうとか
|
|
16
|
+
|
|
17
|
+
```SQL
|
|
18
|
+
|
|
19
|
+
select to_char(age, '+FM00')
|
|
20
|
+
|
|
21
|
+
```
|