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 = NULL ? 1SELECT CASE 2 WHEN NULL = NULL THEN 'NULL Equals to NULL' 3 ELSE 'NULL is NOT Equals to NULL' 4 END NULL_ 5 FROM DUAL; NULL_ NULL is NOT Equals to NULL COUNT with NULLs 1WITH tab 2 AS (SELECT 10 a FROM DUAL 3 UNION ALL 4 SELECT NULL a FROM DUAL 5 UNION ALL 6 …

What is cursor: Pointer to the memory location where the information about sql stmt or DML statement got executed. There are two types of cursors − Implicit Cursor:= Any Select Stmt Or Any SQL Stmt Executed By Oracle Is Through Cursor And User Don’t Have Controlled On Implicit Cursor But Use Can Get Information …

Preview an Image Before Upload Oracle APEX Sometimes we face the requirement like how to show the image before image upload. There are some easy steps to preview images before upload. Create a blank page with two region. One for file browse option and second is sub-region for showing images. Create a Page Item on …

Responsive Classic Report in ORACLE APEX? We have been struggling to have the responsive Oracle APEX Classic Reports for decades now. Standard Oracle APEX which shows the tabular format of the dataset doesn’t support the responsiveness as the device size changes. Let’s take look the DOM rendering of …

How to create Pipelined Functions in Oracle? Pipeline functions are used to return data in tabular format. It returns the data in the nested table type. Pipeline functions are useful to dump data derived from the complex queries. Create the types 1CREATE TYPE g_emp_row AS OBJECT 2( 3 empno NUMBER (4), 4 ename …

How to Change application language after login in ORACLE APEX? In the previous article, we have seen how to translate the application. But what if the user logs in and then want to change the language. Create one dialog page with a select list which holds the list of language. Item Setting: Page Action on Selection: …

Preserve Checkbox state while Paginating in Interactive/Classic Report Oracle APEX Someone has asked this question to me that how can we preserve checked checkboxes in session state. This Problem will come when the user will check few checkboxes and go to next set of rows via pagination in the report when user will go …

Get data from Web Source in Oracle APEX? Working with Oracle and APEX it’s not necessary to keep all the data in the one system. Say you need all the details data in one place and all transaction data in one place, we need DB links or synonyms in case of the same databases. But when the other hand party is not …