tag:blogger.com,1999:blog-8387254584717709129.post7532754732569459533..comments2024-01-22T11:29:03.272-05:00Comments on Oracle Knowledge Center: String FunctionsDelete files older than 9 dayshttp://www.blogger.com/profile/11414713409901236191noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8387254584717709129.post-84552691654098684352010-08-12T14:31:55.513-04:002010-08-12T14:31:55.513-04:00Model Functions :
Model functions are relevant on...Model Functions :<br /><br />Model functions are relevant only for interrow calculations and can be used only in the model_clause of the SELECT statement. They are nonrecursive. The model functions are:<br /><br /><br />CV<br />ITERATION_NUMBER<br />PRESENTNNV<br />PRESENTV<br />PREVIOUSDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-60066837120547008632010-08-12T14:31:35.063-04:002010-08-12T14:31:35.063-04:00Object Reference Functions:
DEREF
MAKE_REF
REF
RE...Object Reference Functions:<br /><br />DEREF<br />MAKE_REF<br />REF<br />REFTOHEX<br />VALUEDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-918254748144136152010-08-12T14:31:12.770-04:002010-08-12T14:31:12.770-04:00Analytic Functions:
AVG *
CORR *
COVAR_POP *
COV...Analytic Functions:<br /> <br />AVG *<br />CORR *<br />COVAR_POP *<br />COVAR_SAMP *<br />COUNT *<br />CUME_DIST<br />DENSE_RANK<br />FIRST<br />FIRST_VALUE *<br />LAG<br />LAST<br />LAST_VALUE *<br />LEAD<br />MAX *<br />MIN *<br />NTILE<br />PERCENT_RANK<br />PERCENTILE_CONT<br />PERCENTILE_DISC<br />RANK<br />RATIO_TO_REPORT<br />REGR_ (Linear Regression) Functions *<br />ROW_NUMBER<br />STDDEV *<br />STDDEV_POP *<br />STDDEV_SAMP *<br />SUM *<br />VAR_POP *<br />VAR_SAMP *<br />VARIANCE *Delete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-29549534249939296012010-08-12T14:29:23.622-04:002010-08-12T14:29:23.622-04:00Aggreate Functions:
AVG
COLLECT
CORR
CORR_*
COUNT...Aggreate Functions:<br /><br />AVG<br />COLLECT<br />CORR<br />CORR_*<br />COUNT<br />COVAR_POP<br />COVAR_SAMP<br />CUME_DIST<br />DENSE_RANK<br />FIRST<br />GROUP_ID<br />GROUPING<br />GROUPING_ID<br />LAST<br />MAX<br />MEDIAN<br />MIN<br />PERCENTILE_CONT<br />PERCENTILE_DISC<br />PERCENT_RANK<br />RANK<br />REGR_ (Linear Regression) Functions<br />STATS_BINOMIAL_TEST<br />STATS_CROSSTAB<br />STATS_F_TEST<br />STATS_KS_TEST<br />STATS_MODE<br />STATS_MW_TEST<br />STATS_ONE_WAY_ANOVA<br />STATS_T_TEST_*<br />STATS_WSR_TEST<br />STDDEV<br />STDDEV_POP<br />STDDEV_SAMP<br />SUM<br />VAR_POP<br />VAR_SAMP<br />VARIANCEDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-68365082673644097672010-08-12T14:28:58.391-04:002010-08-12T14:28:58.391-04:00Miscellaneous Single-Row Functions:
BFILENAME
COA...Miscellaneous Single-Row Functions:<br /><br />BFILENAME<br />COALESCE<br />CV<br />DECODE<br />DEPTH<br />DUMP<br />EMPTY_BLOB, EMPTY_CLOB<br />EXISTSNODE<br />EXTRACT (XML)<br />EXTRACTVALUE<br />GREATEST<br />LEAST<br />LNNVL<br />NLS_CHARSET_DECL_LEN<br />NLS_CHARSET_ID<br />NLS_CHARSET_NAME<br />NULLIF<br />NVL<br />NVL2<br />ORA_HASH<br />PATH<br />PRESENTNNV<br />PRESENTV<br />PREVIOUS<br />SYS_CONNECT_BY_PATH<br />SYS_CONTEXT<br />SYS_DBURIGEN<br />SYS_EXTRACT_UTC<br />SYS_GUID<br />SYS_TYPEID<br />SYS_XMLAGG<br />SYS_XMLGEN<br />UID<br />UPDATEXML<br />USER<br />USERENV<br />VSIZE<br />XMLAGG<br />XMLCOLATTVAL<br />XMLCONCAT<br />XMLFOREST<br />XMLSEQUENCE<br />XMLTRANSFORMDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-78431027670477708672010-08-12T14:28:27.756-04:002010-08-12T14:28:27.756-04:00Collection Functions:
CARDINALITY
COLLECT
POWERMUL...Collection Functions:<br />CARDINALITY<br />COLLECT<br />POWERMULTISET<br />POWERMULTISET_BY_CARDINALITY<br />SETDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-21252835697807070112010-08-12T14:28:03.205-04:002010-08-12T14:28:03.205-04:00Conversion Functions:
ASCIISTR
BIN_TO_NUM
CAST
CHA...Conversion Functions:<br />ASCIISTR<br />BIN_TO_NUM<br />CAST<br />CHARTOROWID<br />COMPOSE<br />CONVERT<br />DECOMPOSE<br />HEXTORAW<br />NUMTODSINTERVAL<br />NUMTOYMINTERVAL<br />RAWTOHEX<br />RAWTONHEX<br />ROWIDTOCHAR<br />ROWIDTONCHAR<br />SCN_TO_TIMESTAMP<br />TIMESTAMP_TO_SCN<br />TO_BINARY_DOUBLE<br />TO_BINARY_FLOAT<br />TO_CHAR (character)<br />TO_CHAR (datetime)<br />TO_CHAR (number)<br />TO_CLOB<br />TO_DATE<br />TO_DSINTERVAL<br />TO_LOB<br />TO_MULTI_BYTE<br />TO_NCHAR (character)<br />TO_NCHAR (datetime)<br />TO_NCHAR (number)<br />TO_NCLOB<br />TO_NUMBER<br />TO_DSINTERVAL<br />TO_SINGLE_BYTE<br />TO_TIMESTAMP<br />TO_TIMESTAMP_TZ<br />TO_YMINTERVAL<br />TO_YMINTERVAL<br />TRANSLATE ... USING<br />UNISTRDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-72759595903942121092010-08-12T14:27:40.366-04:002010-08-12T14:27:40.366-04:00Date Functions:
ADD_MONTHS
CURRENT_DATE
CURRENT_T...Date Functions:<br /><br />ADD_MONTHS<br />CURRENT_DATE<br />CURRENT_TIMESTAMP<br />DBTIMEZONE<br />EXTRACT (datetime)<br />FROM_TZ<br />LAST_DAY<br />LOCALTIMESTAMP<br />MONTHS_BETWEEN<br />NEW_TIME<br />NEXT_DAY<br />NUMTODSINTERVAL<br />NUMTOYMINTERVAL<br />ROUND (date)<br />SESSIONTIMEZONE<br />SYS_EXTRACT_UTC<br />SYSDATE<br />SYSTIMESTAMP<br />TO_CHAR (datetime)<br />TO_TIMESTAMP<br />TO_TIMESTAMP_TZ<br />TO_DSINTERVAL<br />TO_YMINTERVAL<br />TRUNC (date)<br />TZ_OFFSETDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.comtag:blogger.com,1999:blog-8387254584717709129.post-37588974351269532312010-08-12T14:26:35.693-04:002010-08-12T14:26:35.693-04:00Numaric Functions :
ABS
ACOS
ASIN
ATAN
ATAN2
BITA...Numaric Functions :<br /><br />ABS<br />ACOS<br />ASIN<br />ATAN<br />ATAN2<br />BITAND<br />CEIL<br />COS<br />COSH<br />EXP<br />FLOOR<br />LN<br />LOG<br />MOD<br />NANVL<br />POWER<br />REMAINDER<br />ROUND (number)<br />SIGN<br />SIN<br />SINH<br />SQRT<br />TAN<br />TANH<br />TRUNC (number)<br />WIDTH_BUCKETDelete files older than 9 dayshttps://www.blogger.com/profile/11414713409901236191noreply@blogger.com