Coalesce in oracle
COALESCE returns first not null value out of all the parameters passed into this function. NOTE: All the parameters have been the same datatype Copy CodeCopiedUse a different BrowserDROP TABLE coalesce_func_test; CREATE…
Posted inSQL
NULL in ORACLE
NULL in Oracle NULL = NULL ? Copy CodeCopiedUse a different BrowserSELECT CASE WHEN NULL = NULL THEN 'NULL Equals to NULL' ELSE 'NULL is NOT Equals to NULL' END…
How to Generate XML in Oracle Using SQL
Copy CodeCopiedUse a different BrowserSELECT XMLELEMENT ("ROW", XMLFOREST (empno, ename, hiredate, sal, deptno, mgr, comm)) FROM emp; You might like How to parse XLSX and CSV? How to parse JSON…
Remove Special Character and Extra Space From a String ORACLE/PLSQL
Removing special character using REGEXP: SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; Remove extra spaces between string using REGEXP: Copy CodeCopiedUse a different BrowserSELECT REGEXP_REPLACE ('Vikas Pandey from Delhi', '[[:blank:]]+', ' ')…
How to Remove New line from a String Using PL/SQL/ORACLE?
To Remove New line from the string: Copy CodeCopiedUse a different BrowserDECLARE p_sting VARCHAR2 (100) := 'This is Vikas from Delhi Now the next line. '; BEGIN DBMS_OUTPUT.put_line (p_sting); DBMS_OUTPUT.put_line…
ORA-00972: identifier is too long
ORA-00972: identifier is too long. Till Oracle 12 C, the identifier length is 30 characters. Starting from 18 C Oracle increased the length of identifier to 128 character. So now…
Use of Merge Statement
Sometimes whenever we want to insert records into table with the conditions For existing records (if found then) Update, For Non Existing records (If not found) then insert Step 1…
Get the time when was the Record was inserted
To show the posted time or when the data is inserted into the table. The idea of showing the date in this format came from the social site post time…