種類 関数 集計 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