Posted inORACLE SQL

Oracle NULL-Related Functions

Oracle NULL-Related Functions. There are different type of null related function in oracle. NVL NVL function will check whether the first input parameter is null, if its null value, it…
June 3, 2020
Posted inORACLE SQL

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 DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1…
May 21, 2020