Display Image from Directory in ORACLE APEX

Display Image from Directory in ORACLE APEX. One of my colleague had asked to me, How can i display image in Interactive/Classic Report or Interactive Grid from Directory without storing image in table. I got a solution and going to share that how i can achieve in ORACE APEX. STEP 1 : CREATE TABLE USING BELOW QUERY. …

Add Search Option On Nav Bar Oracle APEX

How to Add Search Option On Nav Bar Oracle APEX In Some of the cases wee need to add search field of top of the navigation bar but directly we can’t add it so there is the solution if we edit tamplate so lets start and see how we can get. First go to the Share Components»Templates and copy the navigation …

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 …