Posted inAPEX

Generating JSON using APEX_JSON

Generating JSON using APEX_JSON Sample tables from Oracle Create Two table based on below query and Inserted some record for demo purpose: Copy CodeCopiedUse a different BrowserCREATE TABLE DEPT (…
February 26, 2020
Posted inAPEX

APEX_JSON Nested parsing

APEX_JSON Nested JSON data parsing Sample JSON Copy CodeCopiedUse a different Browser{ "RAW": { "LEVEL_1": "2", "LEVEL_1_ARRAY": [{ "LEVEL_2": { "LEVEL_2_A": "Ashish", "LEVEL_2_ARRAY": [{ "LEVEL_3_A": "00", "LEVEL_3_B": "ABC" }, {…
February 26, 2020
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,…
February 25, 2020
Posted inORACLE PLSQL

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…
February 25, 2020
Posted inAPEX

APEX shortcut variables

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…
February 24, 2020
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…
February 24, 2020