Many times we have faced the problem of trigger Mutating error. errorORA-04091: table TEST1.TEST_MUTATING is mutating, trigger/function may not see it let see how it comes and resolve Create Table CREATE TABLE test_mutating ( id NUMBER, name VARCHAR2(400 byte) ); Create trigger CREATE OR replace TRIGGER t1 …

2 ways to make column nowrap Interactive / Classic Report Oracle APEX SOLUTION 1: Column Formatting => HTML Expression: <span style="white-space:nowrap;">#COLUMN_NAME#</span> SOLUTION 2: Define region Id “regionId” and Column id “HIRE_ID” after that use following CSS: …

2 ways to make column nowrap Interactive / Classic Report Oracle APEX SOLUTION 1: Column Formatting => HTML Expression: <span style="white-space:nowrap;">#COLUMN_NAME#</span> SOLUTION 2: Define region Id “regionId” and Column id “HIRE_ID” after that use following CSS: …

How to Prevent Duplicate Row Interactive Grid Oracle APEX Sometimes user wants to prevent duplicate row on that column where columns don’t have a unique Id or Primary key Identification. On those cases here, I have provided a solution which will definitely help you. Create an editable Interactive Grid using the …

Remove Special Character and Extra Space From a String ORACLE/PLSQL Removing special character using REGEXP: SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; Remove extra spaces between string using REGEXP: SELECT REGEXP_REPLACE ('Vikas Pandey from Delhi', …

How to Remove New line from a String Using PL/SQL/ORACLE To Remove New line from the string: DECLARE p_sting VARCHAR2 (100):= 'This is Vikas from Delhi Now the next line. '; BEGIN DBMS_OUTPUT.put_line (p_sting); DBMS_OUTPUT.put_line ( REPLACE (REPLACE (p_sting, CHR (13), ''), CHR (10), ' ')); …

3 Ways to Open Inline Model Dialog Using JQuery In Oracle APEX In this article, you can learn how to open inline modal dialog in Oracle Apex. There are such different ways to open modal dialog using simple Jquery. Inline modal dialog helps us in a critical situation such as show an error message, for showing report …

Set Row Pagination As Select List In Interactive Grid Oracle APEX Set Row Pagination As Select List In Interactive Grid Oracle APEX I have Created an Interactive Grid using the following SQL Query. select ID, NAME, LOCATION, COUNTRY from DEPARTMENTS Interactive Grid Attribute as per screenshot: Pagination:= Type …