APEX_LANG APEX_LANG.MESSAGE API is great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very usefull to translate the messages or string returned from PL/SQL stored procedures, functions, triggers, packaged procedures, and functions. …

Disable Right Click and Copy Paste In Oracle APEX. If you want to disable right click and Copy paste from your whole application then use below code globle page. Create Dynamic action and paste below code. Event > Page load. Action > Execute JavaScript code. If you want to use only in single page then copy and …

Order tracking progress bar in Oracle APEX. Create a blank page with select list item as per screenshot. Create region with region type plsql dynamic content and use below code. DECLARE l_app NUMBER := v ('APP_ID'); l_session NUMBER := v ('APP_SESSION'); CURSOR c_check_open IS SELECT 1 FROM DUAL …

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

Why APEX Plugins? Oracle application express or widely known as APEX is a great framework that comes up with endless possibilities. Forms, Reports flexible and responsible designs which help to make your app platform-independent. JavaScript, CSS, JQuery, third-party library integration, Plugins, Templates and whatnot. …

APEX Camera Extension (ACE) Plugin. APEX Camera Extension (ACE) plugin allows user to open Camera and and capture an image in APEX Collection. How to use? Steps: Download Plugin. Install this plugin into your application. Create a page region with button. Create a dynamic action on button. Create True action. Choose …

How to Calculate total sum of interactive grid column into page item in oracle APEX. Most of the time, this question was asked by my friends and colleagues that “How to Calculate total sum of interactive grid column into page item in oracle APEX” then i got solution in two ways. Solution 1. Need to create …

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 …

Here is the requirement for refreshing the report on base page,to do so i am just creating a Dynamic Action (DA) :- Parent Page : Create Dynamic action Event > Dialog Closed Selection type > Javascript Expression Condition > JavaScript Expression> window If You are working with above Apex 5.0 then …

Checkboxes are little bit tricky and difficult. I was trying to implement it for long time but it’s bit problematic than i thought. After John Snyders cookbook update for 19.2 things are very easy. I would like to recommend to go through Jhon’s Updates He has implemented the checkbox in Interactive Grid. I …

Mega Menu Oracle APEX Mega Menu is collapsible floating panel which displays navigation entries at once. It enables users to reduce number of clicks to navigate. Features of Mega Menu Customizable Icons, Descriptions, and Badges Responsive Accessible and Keyboard Friendly How to create? Mega menu can use the exiting …

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

How to check duplicate record in table SQL/Oracle? Create table using following script: CREATE TABLE TEST_EMP ( ENAME VARCHAR2(10 BYTE), DEPTNO NUMBER(2), ID NUMBER ) Run following script for demo purpose. SET DEFINE OFF; Insert into TEST_EMP (ENAME, DEPTNO, ID) Values ('SMITH', 20, 1); Insert into TEST_EMP …

How to delete duplicate record From table using SQL/Oracle? Create table using following script: CREATE TABLE TEST_EMP ( ENAME VARCHAR2(10 BYTE), DEPTNO NUMBER(2), ID NUMBER ) Run following script for demo purpose. SET DEFINE OFF; Insert into TEST_EMP (ENAME, DEPTNO, ID) Values ('SMITH', 20, 1); Insert into …

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