Kayshav.com
About Developer Oracle 12c Oracle 19c Technology Information Sitemap

Oracle 12c Functions
-- Oracle 12c: SQL Functions

-- This function is useful in validation the datatype 

SELECT
  VALIDATE_CONVERSION(1000 AS BINARY_DOUBLE) is_binary_double,
  VALIDATE_CONVERSION(NULL AS BINARY_DOUBLE) is_binary_double
FROM DUAL;

-- This function APPROX_COUNT_DISTINCT is useful to compute approximate
-- counts in large tables

SELECT
 APPROX_COUNT_DISTINCT(customer_id) approx_customer_cnt,
 COUNT(DISTINCT customer_id) dist_customer_cnt
FROM edw_fact_sales
;


WITH syntax in Oracle 12c

LISTAGG in Oracle 12c

Oracle 12c Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: July 28th, 2016

  11052