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) …

Cursors in PL/SQL

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

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 …

Pipelined Functions in Oracle

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 CREATE TYPE g_emp_row AS OBJECT ( empno NUMBER (4), ename VARCHAR2 (10 …

Change Language anytime in Oracle APEX

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: …

APEX Split Login template experiment

How to Add new region position in APEX login page? APEX has been upgraded it login templates all the way from simple region to login template region then in APEX it is also available with split design. Since I have been playing around the APEX templates and themes i found we could add region position to our APEX page …