Use of Merge Statement
Sometimes whenever we want to insert records into table with the conditions For existing records (if found then) Update, For Non Existing records (If not found) then insert Step 1…
Posted inORACLE
Refresh a materialized view
To refresh a Materialized view we need DBMS_SNAPSHOT.REFRESH procedure. Steps. CREATE TABLE demo_m ( id NUMBER (10) primary key, name VARCHAR2 (400) ); / INSERT INTO DEMO_M ( ID, NAME)…
Posted inORACLE
Get Current Schema and DB name
Some times we do not know about our schema exist in which db and which is our schema hare is the method to find db and schema name. Copy CodeCopiedUse…
Posted inORACLE
RANK and DENSE_RANK
RANK() : function always returns sequential order for each record.DENSE_RANK() : It returns continuous order for each record. Copy CodeCopiedUse a different BrowserSELECT empno, deptno, sal, mgr, RANK () OVER (PARTITION BY…
Posted inORACLE
Handle trigger Mutating Error
Many times we have faced the problem of trigger Mutating error. error ORA-04091: table TEST1.TEST_MUTATING is mutating, trigger/function may not see it let see how it comes and resolve Create…
Posted inAPEX
Disable Date Picker In Oracle APEX
We will disable the date picker because sometimes we don’t need to allow editing (due to some privilege ). The approach is using JQuery:Create a JavaScript function : Copy CodeCopiedUse…
Posted inORACLE
Constraints in Nested table
In my previous blog “Working With Nested Table Oracle ” I explained how to work with nested tables. Here we can also define Constraints to the nested table. According to the…
Posted inAPEX
Set item at right of interactive Report search bar Oracle APEX
How to Set item at right of APEX interactive Report search bar? We can set the position of any item at the right of the interactive search bar by using…
Posted inORACLE
Working With Nested Table Oracle
Nested table is awesome feature of Oracle. You can create table inside a table, Which means one column can be treated as a table. Nested tables are faster than the…
Posted inAPEX
Avoid printing interactive report column
Use following expression as column condition and column will not print. Copy CodeCopiedUse a different BrowserNVL (SUBSTR (:request, INSTR (:request, '_', -1) + 1), 'ASHISH') NOT IN ('XLS', 'CSV', 'HTMLD',…