본문 바로가기

[오라클 레퍼런스 함수] 목차

by ㅇㅍㅍ 2023. 7. 28.
[오라클 레퍼런스 함수] 목차
728x90
 

 오라클 함수 목록

 ABS

 ACOS

 ADD_MONTHS

 ANY_VALUE

 APPROX_COUNT

 APPROX_COUNT_DISTINCT

 APPROX_COUNT_DISTINCT_AGG

 APPROX_COUNT_DISTINCT_DETAIL

 APPROX_MEDIAN

 APPROX_PERCENTILE

 APPROX_PERCENTILE_AGG

 APPROX_PERCENTILE_DETAIL

 APPROX_RANK

 APPROX_SUM

 ASCII

 ASCIISTR

 ASIN

 ATAN

 ATAN2

 AVG

 BFILENAME

 BIN_TO_NUM

 BITAND

 BITMAP_BIT_POSITION

 BITMAP_BUCKET_NUMBER

 BITMAP_CONSTRUCT_AGG

 BITMAP_COUNT

 BITMAP_OR_AGG

 CARDINALITY

 CAST

 CEIL

 CHARTOROWID

 CHR

 CLUSTER_DETAILS

 CLUSTER_DISTANCE

 CLUSTER_ID

 CLUSTER_PROBABILITY

 CLUSTER_SET

 COALESCE

 COLLATION

 COLLECT

 COMPOSE

 CON_DBID_TO_ID

 CON_GUID_TO_ID

 CON_ID_TO_CON_NAME

 CON_ID_TO_DBID

 CON_NAME_TO_ID

 CON_UID_TO_ID

 CONCAT

 CONVERT

 CORR

 CORR_*

 COS

 COSH

 COUNT

 COVAR_POP

 COVAR_SAMP

 CUBE_TABLE

 CUME_DIST

 CURRENT_DATE

 CURRENT_TIMESTAMP

 CV

 DATAOBJ_TO_MAT_PARTITION

 DATAOBJ_TO_PARTITION

 DBTIMEZONE

 DECODE

 DECOMPOSE

 DENSE_RANK

 DEPTH

 DEREF

 DUMP

 EMPTY_BLOB, EMPTY_CLOB

 EXISTSNODE

 EXP

 EXTRACT (datetime)

 EXTRACT (XML)

 EXTRACTVALUE

 FEATURE_COMPARE

 FEATURE_DETAILS

 FEATURE_ID

 FEATURE_SET

 FEATURE_VALUE

 FIRST

 FIRST_VALUE

 FLOOR

 FROM_TZ

 GREATEST

 GROUP_ID

 GROUPING

 GROUPING_ID

 HEXTORAW

 INITCAP

 INSTR

 ITERATION_NUMBER

 JSON_ARRAY

 JSON_ARRAYAGG

 JSON_DATAGUIDE

 JSON_MERGEPATCH

 JSON_OBJECT

 JSON_OBJECTAGG

 JSON_QUERY

 JSON_SERIALIZE

 JSON_TABLE

 JSON_TRANSFORM

 JSON_VALUE

 LAG

 LAST

 LAST_DAY

 LAST_VALUE

 LEAD

 LEAST

 LENGTH

 LISTAGG

 LN

 LNNVL

 LOCALTIMESTAMP

 LOG

 LOWER

 LPAD

 LTRIM

 MAKE_REF

 MAX

 MEDIAN

 MIN

 MOD

 MONTHS_BETWEEN

 NANVL

 NCHR

 NEW_TIME

 NEXT_DAY

 NLS_CHARSET_DECL_LEN

 NLS_CHARSET_ID

 NLS_CHARSET_NAME

 NLS_COLLATION_ID

 NLS_COLLATION_NAME

 NLS_INITCAP

 NLS_LOWER

 NLS_UPPER

 NLSSORT

 NTH_VALUE

 NTILE

 NULLIF

 NUMTODSINTERVAL

 NUMTOYMINTERVAL

 NVL

 NVL2

 ORA_DM_PARTITION_NAME

 ORA_DST_AFFECTED

 ORA_DST_CONVERT

 ORA_DST_ERROR

 ORA_HASH

 ORA_INVOKING_USER

 ORA_INVOKING_USERID

 PATH

 PERCENT_RANK

 PERCENTILE_CONT

 PERCENTILE_DISC

 POWER

 POWERMULTISET

 POWERMULTISET_BY_CARDINALITY

 PREDICTION

 PREDICTION_BOUNDS

 PREDICTION_COST

 PREDICTION_DETAILS

 PREDICTION_PROBABILITY

 PREDICTION_SET

 PRESENTNNV

 PRESENTV

 PREVIOUS

 RANK

 RATIO_TO_REPORT

 RAWTOHEX

 RAWTONHEX

 REF

 REFTOHEX

 REGEXP_COUNT

 REGEXP_INSTR

 REGEXP_REPLACE

 REGEXP_SUBSTR

 REGR_ (Linear Regression) Functions

 REMAINDER

 REPLACE

 ROUND (date)

 ROUND (number)

 ROUND_TIES_TO_EVEN (number)

 ROW_NUMBER

 ROWIDTOCHAR

 ROWIDTONCHAR

 RPAD

 RTRIM

 SCN_TO_TIMESTAMP

 SESSIONTIMEZONE

 SET

 SIGN

 SIN

 SINH

 SOUNDEX

 SQRT

 STANDARD_HASH

 STATS_BINOMIAL_TEST

 STATS_CROSSTAB

 STATS_F_TEST

 STATS_KS_TEST

 STATS_MODE

 STATS_MW_TEST

 STATS_ONE_WAY_ANOVA

 STATS_T_TEST_*

 STATS_WSR_TEST

 STDDEV

 STDDEV_POP

 STDDEV_SAMP

 SUBSTR

 SUM

 SYS_CONNECT_BY_PATH

 SYS_CONTEXT

 SYS_DBURIGEN

 SYS_EXTRACT_UTC

 SYS_GUID

 SYS_OP_ZONE_ID

 SYS_TYPEID

 SYS_XMLAGG

 SYS_XMLGEN

 SYSDATE

 SYSTIMESTAMP

 TAN

 TANH

 TIMESTAMP_TO_SCN

 TO_APPROX_COUNT_DISTINCT

 TO_APPROX_PERCENTILE

 TO_BINARY_DOUBLE

 TO_BINARY_FLOAT

 TO_BLOB (bfile)

 TO_BLOB (raw)

 TO_CHAR (bfile|blob)

 TO_CHAR (character)

 TO_CHAR (datetime)

 TO_CHAR (number)

 TO_CLOB (bfile|blob)

 TO_CLOB (character)

 TO_DATE

 TO_DSINTERVAL

 TO_LOB

 TO_MULTI_BYTE

 TO_NCHAR (character)

 TO_NCHAR (datetime)

 TO_NCHAR (number)

 TO_NCLOB

 TO_NUMBER

 TO_SINGLE_BYTE

 TO_TIMESTAMP

 TO_TIMESTAMP_TZ

 TO_UTC_TIMESTAMP_TZ

 TO_YMINTERVAL

 TRANSLATE

 TRANSLATE ... USING

 TREAT

 TRIM

 TRUNC (date)

 TRUNC (number)

 TZ_OFFSET

 UID

 UNISTR

 UPPER

 USER

 USERENV

 VALIDATE_CONVERSION

 VALUE

 VAR_POP

 VAR_SAMP

 VARIANCE

 VSIZE

 WIDTH_BUCKET

 XMLAGG

 XMLCAST

 XMLCDATA

 XMLCOLATTVAL

 XMLCOMMENT

 XMLCONCAT

 XMLDIFF

 XMLELEMENT

 XMLEXISTS

 XMLFOREST

 XMLISVALID

 XMLPARSE

 XMLPATCH

 XMLPI

 XMLQUERY

 XMLROOT

 XMLSEQUENCE

 XMLSERIALIZE

 XMLTABLE

 XMLTRANSFORM

 

 

 

 

반응형

댓글