Table Blob to Oracle Directory
Posted inORACLE PLSQL

Table Blob to Oracle Directory

How to save table images to oracle directory? Files from table to Oracle directory Copy CodeCopiedUse a different BrowserDECLARE l_file UTL_FILE.file_type; l_buffer RAW (32767); l_amount BINARY_INTEGER := 32767; l_position INTEGER…
June 20, 2020
Posted inORACLE

Oracle NULLIF() Function

Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the…
June 9, 2020
Posted inORACLE

Oracle NVL2 Function

Oracle NVL2 Function: NVL2() function is an extend version of the NVL() function with different options based on whether a NULL value exists. Oracle NVL2() function allow three parameters. If…
June 4, 2020
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

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…
June 3, 2020
Posted inORACLE 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 returns the default value. The Oracle/PLSQL DECODE function…
June 3, 2020
Posted inORACLE SQL

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…
May 21, 2020
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…
May 12, 2020