Slide 144
Slide 144 text
各ファンクションの詳細はドキュメントを参照
演算子で利用できる関数
Copyright © 2024, Oracle and/or its affiliates
144
種類 関数
集計 COUNT,MAX,MIN,SUM,AVG,LISTAGG
分析 FIRST_VALUE ,LAG,LAST_VALUE,LEAD,RANK,ROW_NUMBER
算術 ABS,CEIL,FLOOR,MOD,POWER,ROUND,TRUNC,TO_NUMBER
条件 COALESCE,NULLIF
日付/時刻 CURRENT_DATE,CURRENT_TIMESTAMP,DATE_ADD,DATE_FORMAT,DAYOFMONTH,DAYOFWEEK,DAYOFYEA
R,HOUR,LAST_DAY,MINUTE,MONTH,QUARTER,SECOND,TO_DATE,TO_TIMESTAMP,WEEK,YEAR,ADD_MONT
HS,MONTHS_BETWEEN,FROM_UTC_TIMESTAMP,TO_UTC_TIMESTAMP,FROM_UNIXTIME,UNIX_TIMSTAMP,I
NTERVAL
ハッシュ MD5,SHA1,SHA2,ORA_HASH
階層 SCHEMA_OF_JSON,FROM_JSON,TO_JSON,TO_MAP,TO_STRUCT,TO_ARRAY
高次 TRANSFORM,TRANSFORM_KEYS,TRANSFORM_VALUES
比較 CASE WHEN、AND,OR,NOT,LIKE,=,!=,>,>=,<,<=,||,BETWEEN,IN
文字列 CAST,CONCAT,INITCAP,INSTR,LOWER,LENGTH,LTRIM,NVL,REGEXP_SUBSTR,REPLACE,RTRIM,SUBSTRING,T
O_CHAR,UPPER,LPAD,RPAD
一意のID NUMERIC_ID,ROWID,UUID,MONOTONICALLY_INCREASING_ID