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 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
Disable Date Picker In Oracle APEX
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…
April 12, 2017
Avoid printing interactive report column
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',…
March 14, 2017