function | Ontoor Solutions Blogs

Oracle Decode Function

Posted by - Vikas Pandey Jun 3, 2020 ORACLE PLSQL Function SQL

Oracle Decode Function: Oracle DECODE() function compares the first argument with the second argument. IF they are equal, the function returns the third argument otherwise return default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: 1SELECT DECODE (1, 1, 'ONE', …
Read More
Coalesce in oracle

Posted by - Ashish Sahay May 21, 2020 Coalesce PLSQL SQL function

Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype 1DROP TABLE coalesce_func_test; 2 3CREATE TABLE coalesce_func_test 4( 5 id NUMBER, 6 col1 VARCHAR2 (10), 7 col2 VARCHAR2 (10), 8 col3 VARCHAR2 (10), 9 col4 NUMBER 10); …
Read More