Posted inGITHUB
GitHub Account setup
GitHub Account setup: GitHub is “Built for developers"and a development platform inspired by the way you work. From open source to business, you can host and review code, manage projects,…
PLSQL Collection Data Deletion
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; / Copy CodeCopiedUse a…
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…
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…