Useful Oracle functions used in queries in this website APPROX_COUNT_DISTINCT BITAND BIN_TO_NUM CUBE, GROUPING, GROUPING_ID GROUPING, GROUPING SETS CASE CAST CEIL COALESCE CONVERT DECODE, SIGN FLOOR GREATEST GROUPING_ID HEXTORAW, RAWTOHEX INITCAP LEAST MOD NVL2 POWER ROLLUP TO_CHAR TRANSLATE VALIDATE_CONVERSION WIDTH_BUCKET Analytic Functions COUNT(*) OVER() DENSE_RANK FIRST FIRST_VALUE LAG LAST LAST_VALUE LEAD LISTAGG NTILE PERCENT_RANK RANK RATIO_TO_REPORT ROW_NUMBER SUM(..) OVER() Date and Time Functions And Constants ADD_MONTHS CURRENT_DATE, CURRENT_TIMESTAMP DBTIMEZONE, SESSIONTIMEZONE EXTRACT FROM_TZ, TO_TIMESTAMP, TO_TIMESTAMP_TZ, TZ_OFFSET LAST_DAY, NEXT_DAY LOCAL_TIMESTAMP, SYSTIMESTAMP MONTHS_BETWEEN NEW_TIME, SYS_EXTRACT_UTC Regular Expression REGEXP_COUNT REGEXP_LIKE REGEXP_REPLACE REGEXP_SUBSTR Statistical Functions Correlation - CORR Covariance Sample, Population - COVAR_SAMP, COVAR_POP Regression Slope, Intercept - REGR_SLOPE, REGR_INTERCEPT Regression - REGR_SXX, REGR_SXY, REGR_SYY REGR_AVGX, REGR_AVGY, REGR_COUNT Standard Deviation, Sample, Population - STDDEV, STDDEV_SAMP, STDDEV_POP Variance, Population, Sample - VARIANCE, VAR_POP, VAR_SAMP String Functions CONVERT INSTR REVERSE SOUNDEX SUBSTR XML Functions XML_COMMENT, XMLELEMENT, XMLPI, XMLROOT, XMLParse, XMLQUERY, ....
23590