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 …

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 …

Get Images from ORACLE REST Web Service

How to get Images from ORACLE REST Web Service ? Oracle REST APIs provides the feature of media resource, here we can write the query with two columns content type and image blob. While i was trying to implement i saw tweaks, the query has to be in below format only. SELECT 'content_type', column FROM . . …

How to Write Good User Stories

How to write good User stories? Writing good user stories is always a challenging job, In this process you always try to inline with the standards and business goals. For me it is just an initiative for any task/feature to our product and gateway to give the insights of product to the Development Team. Now let’s …

New Version Control in Oracle APEX 20

New Version Control in Oracle APEX 20.1. As we know APEX came with new APEX export utility in Version 20.1. Let’s have a walk through how is works. Also Checkout related articles New Updates in APEX 20.1. APEX 20.1 First look In old APEX versions we had to manually export all the components like Pages, Shared …

Reading File From Oracle Directory

How to read Files from Oracle Directory using PL/SQL? File Structure ACCOUNTING RESEARCH SALES OPERATIONS 3 Records 5 Records 6 Records 0 Records How to generate files into Oracle Directory? DECLARE l_file UTL_FILE.file_type; l_read VARCHAR2 (32767); BEGIN l_file := UTL_FILE.fopen ('MY_DIR', …

Forms Reloaded APEX 19.2 Part 2

APEX Form region On Query | Part 2. Let’s try some insights of APEX form region. Below script to add Emp and Dept if you don’t have. CREATE TABLE dept ( deptno NUMBER (2) CONSTRAINT pk_dept PRIMARY KEY, dname VARCHAR2 (14), loc VARCHAR2 (13) ); CREATE TABLE emp ( empno NUMBER (4) CONSTRAINT pk_emp PRIMARY …

Forms Reloaded APEX 19.2 | Part 1

What are the upgrades in APEX Forms as of APEX 19.2? Oracle APEX form is being great component for interacting with database. These are basically require very low code to build and seem less functionality. There are significant upgrades in APEX forms from APEX 18 to APEX 19. let’s walk through them. APEX 18.2 …