Table Blob to Oracle Directory

How to save table images to oracle directory? Files from table to Oracle directory DECLARE l_file UTL_FILE.file_type; l_buffer RAW (32767); l_amount BINARY_INTEGER := 32767; l_position INTEGER := 1; l_blob_length INTEGER; BEGIN FOR l_cnt IN (SELECT filename, product_image FROM demo_product_info) LOOP l_file := …

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 NULLIF() function returns the first argument and if any arguments will null then function return an error. Syntax of the NULLIF() …

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 the first parameter is not null, then it returns the second parameter. In case the second parameter is null, then it returns the …

Oracle Decode Function

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

Oracle NVL Function

Oracle NVL Function: The NVL function allow you to replace null values with a default value. If the first parameter is null, the function returns the second parameter. If the first parameter have some value then always return first value. Note := NVL function replaces null value with same type data. Syntax of the …

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 returns the second parameter value. DECODE The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. * …

Application header with text in ORACLE APEX

How to set the Application header with text in ORACLE APEX? We have been asked about setting up the Application logo with the text string. Let’s take a look version by version. APEX 5 and APEX 18 In APEX 5 and APEX 18 we can only set up a logo or text at a time. So what if we need to display text and logo …

Coalesce in oracle

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 ); Sample Data SET …

Coalesce in oracle

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 ); Sample Data SET …

Oracle APEX Multi Language translation

How to translate Oracle APEX into Multi-Languages? In application development, multilanguage translation is always a tedious job to accomplish. But when it comes to APEX is just like couple of steps. Found Interesting? Let’s see….. Language Selector Select all the available languages for the application. …

NULL in ORACLE

NULL in Oracle NULL = NULL ? SELECT CASE WHEN NULL = NULL THEN 'NULL Equals to NULL' ELSE 'NULL is NOT Equals to NULL' END NULL_ FROM DUAL; NULL_ NULL is NOT Equals to NULL COUNT with NULLs WITH tab AS (SELECT 10 a FROM DUAL UNION ALL SELECT NULL a FROM DUAL UNION ALL SELECT 2 a FROM DUAL) …