Accordion Report plugin | Oracle APEX
Accordian Report is a great interface when you want to utilize the screen space. I took the references from the Accrodian library and used to implement it in Oracle APEX.…
Social Footer Oracle APEX
The social footer is one of my plugins. I have created this plugin to avoid writing code over and over and static codes in HTML for showing social icons or…
Posted inORACLE
Row level, statement level Trigger
Create two tables based on the query: Copy CodeCopiedUse a different BrowserCREATE TABLE product ( MESSAGE VARCHAR2 (50), CURRENT_DATE DATE ); CREATE TABLE product_log ( MESSAGE VARCHAR2 (4000), CURRENT_DATE DATE…
Smooth row view Interactive report Oracle APEX
In APEX interactive reports when we switch the report view from table view to row view, we use to see too much lag and screen loading. like below… It might…
Create user in Oracle 12 C
Create user 12C: connect system/manager as sysdba alter session set "_ORACLE_SCRIPT"=true; / create user lime identified by limeoracle; / grant dba to lime; / connect lime/limeoracle / create table test(lime…
Posted inORACLE Oracle Tutorials
Oracle Functions
NVL2 Function COALESCE Function DECODE Function NULLIF Function
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…