PLSQL collection data deletion CREATE OR REPLACE TYPE l_rec_type IS OBJECT (id NUMBER, name VARCHAR2 (1111)); / CREATE OR REPLACE TYPE l_tab_type IS TABLE OF l_rec_type; / Read more
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. Steps { "showIcon": "fa-plus-square fa-2x", "hideIcon": "fa-minus-square fa-2x", "headingBackground": "red",... Read more
APEX shortcut variables are best in dynamic use in Javascript code. We can fetch data from database or can use any hard coded text. Use a shortcut to define frequently used code once and then reference it in many places... Read more
Create two tables based on the query: insert into product values ('ashish',sysdate); / update product set message = 'Ashish Sahay' where current_date = sysdate; / Read more
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 impact user experience, sometimes report may have too much data... Read more
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 number); Read more
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 : Create table a_merge as select empno , ename from... Read more
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) VALUES (1001, 'VIKAS' ); / SELECT * FROM demo_m; One... Read more