Restful API using ORDS
Creating Rest API using ORDS ORDS APIs follows the Module, Template, Method. Now let see the Hierarchy of these. Module is top level container, it can contain set of templates .Template is at…
Consuming ORDS Rest APIs using PL/SQL
Consuming ORDS Rest APIs using PL/SQL API End point : https://apex.oracle.com/pls/apex/ashish_portfolio/hr/test_emp Parameters : deptno, empno Method : GET Without parameters Copy CodeCopiedUse a different BrowserDeclare l_clob CLOB; BEGIN l_clob :=…
Posted inAPEX
Clob to Blob Using APEX Web Service
CLOBBASE642BLOB Function This function is used to convert Clob to base64Blob. Syntax APEX_WEB_SERVICE.CLOBBASE642BLOB ( p_clob IN CLOB) RETURN BLOB; Example declare l_clob CLOB; l_blob BLOB; l_blob_2 BLOB; begin SELECT BLOB_CONTENT…
Posted inAPEX
Use of $s $x $v
$x $x is used to find the control on the DOM meaning looking for any item available on DOM. If the control is found then it returns the dom of the…
Posted inAPEX
How to change an item’s LABEL and Placeholder dynamically using a Dynamic Action
How to change an item’s LABEL and Placeholder dynamically using a Dynamic Action To change ITEM labels and placeholders we can try some JavaScript way to do so. Look around…
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 (…
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" }, {…
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 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…
