目次
- 表一覧
- タイトルおよび著作権情報
- はじめに
- 1 基本要素
- 2 OLAP関数
-
3 行関数
- 行関数(アルファベット順)
- 行関数(カテゴリ別)
- ABS
- ACOS
- ADD_MONTHS
- ASCII
- ASCIISTR
- ASIN
- ATAN
- ATAN2
- BIN_TO_NUM
- BITAND
- CAST
- CEIL
- CHARTOROWID
- CHR
- COALESCE
- CONCAT
- COS
- COSH
- CURRENT_DATE
- CURRENT_TIMESTAMP
- DBTIMEZONE
- DECODE
- EXP
- EXTRACT (日時)
- FLOOR
- FROM_TZ
- GREATEST
- HEXTORAW
- INITCAP
- INSTR
- LAST_DAY
- LEAST
- LENGTH
- LN
- LNNVL
- LOCALTIMESTAMP
- LOG
- LOWER
- LPAD
- LTRIM
- MOD
- MONTHS_BETWEEN
- NANVL
- NEW_TIME
- NEXT_DAY
- NLS_CHARSET_ID
- NLS_CHARSET_NAME
- NLS_INITCAP
- NLS_LOWER
- NLS_UPPER
- NLSSORT
- NULLIF
- NUMTODSINTERVAL
- NUMTOYMINTERVAL
- NVL
- NVL2
- ORA_HASH
- POWER
- RAWTOHEX
- REGEXP_COUNT
- REGEXP_REPLACE
- REGEXP_INSTR
- REGEXP_SUBSTR
- REMAINDER
- REPLACE
- ROUND (日付)
- ROUND (数値)
- ROWIDTOCHAR
- ROWIDTONCHAR
- RPAD
- RTRIM
- SESSIONTIMEZONE
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- SUBSTR
- SYS_CONTEXT
- SYSDATE
- SYSTIMESTAMP
- TAN
- TANH
- TO_BINARY_DOUBLE
- TO_BINARY_FLOAT
- TO_CHAR (文字)
- TO_CHAR (日時)
- TO_CHAR (数値)
- TO_DATE
- TO_DSINTERVAL
- TO_NCHAR (文字)
- TO_NCHAR (日時)
- TO_NCHAR (数値)
- TO_NUMBER
- TO_TIMESTAMP
- TO_TIMESTAMP_TZ
- TO_YMINTERVAL
- TRANSLATE
- TRANSLATE (USING)
- TRIM
- TRUNC (数値)
- TZ_OFFSET
- UID
- UNISTR
- UPPER
- USER
- VSIZE
- WIDTH_BUCKET
- A 予約語
- 索引