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
You might like Read more
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
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 we can define our identifiers till 128 characters if you... Read more
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 : Create table a_merge as select empno , ename from... Read more
Hey Guys, Some times we need to show the posted time or you can say when the data is inserted into the table. The idea of showing date in this format came from the social site post time display schemes... Read more