|
| |
select
Round(123.456) as 四捨五入1
,Round(123.456,2) as 四捨五入2
,Fix(123.456) as 切捨て
,Format(123456,'#,###') as 数値編集1
,Format(123456,'#,##0') as 数値編集2
,Instr('ABCDEFG','CDE') as 文字列検索
,UCase('abc') as 大文字
,LCase('ABC') as 小文字
,10 MOD 4 as 余り
| |
|
| 四捨五入1 | 四捨五入2 | 切捨て | 数値編集1 | 数値編集2 | 文字列検索 | 大文字 | 小文字 | 余り |
|---|
| 123 | 123.46 | 123 | 123,456 | 123,456 | 3 | ABC | abc | 2 |
|
|
| |
select
ROUND(123.456,0) as 四捨五入1
,ROUND(123.456,1) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入2
,ROUND(123.456,0,1) as 切捨て1
,ROUND(123.456,2,1) as 切捨て2
,ROUND(123.456,-1,1) as 切捨て3
,PATINDEX('%CDE%', 'ABCDEFG') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,10 % 4 as 余り
,REPLACE(CONVERT(VARCHAR(20),CONVERT(money,123456),1),'.00','') as 整数編集
| |
|
| 四捨五入1 | 四捨五入2 | 四捨五入2 | 切捨て1 | 切捨て2 | 切捨て3 | 文字列検索 | 文字列置換 | 大文字 | 小文字 | 余り | 整数編集 |
|---|
| 123 | 123.5 | 120 | 123 | 123.45 | 120 | 3 | ABxxxFG | ABC | abc | 2 | 123,456 |
|
|
| |
select
ROUND(123.456) as 四捨五入1
,ROUND(123.456,2) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入3
,TRUNCATE(123.456,1) as 切捨て1
,TRUNCATE(123.456,-1) as 切捨て2
,LPAD('ABC','6','0') as 埋め込み1
,RPAD('ABC','6','0') as 埋め込み2
,INSTR('ABCDEFG','CDE') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,MOD(10,4) as 余り
| |
|
|
|
| |
select
ROUND(123.456) as 四捨五入1
,ROUND(123.456,2) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入3
,TRUNC(123.456) as 切捨て1
,TRUNC(123.456,2) as 切捨て2
,TRUNC(123.456,-1) as 切捨て3
,TO_CHAR(123456,'999,999') as 数値編集
,TO_CHAR(123,'00000') as 先行ゼロ編集
,TO_CHAR(12345,'FM9999999999') as 文字列へ変換
,LPAD('ABC','6','0') as 埋め込み1
,RPAD('ABC','6','0') as 埋め込み2
,POSITION('CDE' in 'ABCDEFG') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,MOD(10,4) as 余り
| |
|
| 四捨五入1 | 四捨五入2 | 四捨五入3 | 切捨て1 | 切捨て2 | 切捨て3 | 数値編集 | 先行ゼロ編集 |
|---|
| 123 | 123.46 | 120 | 123 | 123.45 | 120 | 123,456 | 123 |
| 文字列へ変換 | 埋め込み1 | 埋め込み2 | 文字列検索 | 文字列置換 | 大文字 | 小文字 | 余り |
|---|
| 12345 | 000ABC | ABC000 | 3 | ABxxxFG | ABC | abc | 2 |
|
|
| |
select
ROUND(123.456) as 四捨五入1
,ROUND(123.456,2) as 四捨五入2
,ROUND(123.456,-1) as 四捨五入3
,TRUNC(123.456) as 切捨て1
,TRUNC(123.456,2) as 切捨て2
,TRUNC(123.456,-1) as 切捨て3
,TO_CHAR(123456,'999,999') as 数値編集
,TO_CHAR(123,'00000') as 先行ゼロ編集
,LPAD('ABC','6','0') as 埋め込み1
,RPAD('ABC','6','0') as 埋め込み2
,INSTR('ABCDEFG','CDE') as 文字列検索
,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
,UPPER('abc') as 大文字
,LOWER('ABC') as 小文字
,MOD(10,4) as 余り
from dual
| |
|
|
|