Oracle NULL-Related Functions

Oracle NULL-Related Functions. There are different type of null related function in oracle. Read more

Oracle NVL Function

The NVL function allows you to replace null values with a default values. If the first parameter is null, the function returns the second parameter. If the first parameter has some value then always return the first value. Note:= NVL... Read more

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 returns the default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: SELECT DECODE (1,... Read more

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 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER... Read more


NULL in Oracle NULL = NULL ? NULL_ NULL is NOT Equals to NULL COUNT with NULLs COUNT(A) 2 SUM with NULLs SUM(A) 12 LENGTH with NULLs SELECT LENGTH (NULL) len, 'LENGTH' FROM DUAL; LEN ‘LENGTH’ LENGTH Order by with... Read more

Cursors in PL/SQL

What is cursor: Pointer to the memory location where the information about sql stmt or DML statement got executed. There are two types of cursors − Implicit Cursor:= Any Select Stmt Or Any SQL Stmt Executed By Oracle Is Through Cursor And... Read more

How to Parse JSON Using APEX Data Parser in Oracle?

How to Parse Json Using APEX Data Parser in Oracle? Sample JSON Parsing Query file_content holds the whole JSON data. Output  You might like Read more

How to Parse XML in Oracle

How to parse XML using APEX_DATA_PARSER?  Get the XML data. Parsing Query You might also like Read more

APEX Data Parser – How to Parse XLSX and CSV

APEX Data Parser – How to Parse XLSX and CSV?  PARSE Function This is the main parser function. It allows to parse XML, XLSX, CSV or JSON files and returns a generic table of the following structure: Structure of parser... Read more

Remove Special Character and Extra Space From a String ORACLE/PLSQL

SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; You might Like How to Remove New line from a String Using PL/SQL/ORACLE Read more