Data TypesThe data types used by the APEX_ZIP package.t_filestype t_files is table of varchar2(32767) index by binary_integer; Reference You might Like Read more
Page groups are very helpful for developers to manage application pages. Developer can use Page Groups to club the similar kind of Pages. These groups give the a centralized management for pages, For example if developer needs to build an... Read more
BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: Example : References: apex_web_service.blob2clobbase64 Read more
Firstly we need to enable ORDS. Base url : <SERVER_URL>:<SERVER_PORT>/ords/ To hide the schema name from API endpoint we put any alias in url mapping pattern. BEGIN ORDS.enable_schema( p_enabled => TRUE, p_schema => '<SCHEMA_NAME>', p_url_mapping_type => 'BASE_PATH', p_url_mapping_pattern => '<ANY_ALIAS_INPLACE_OF_SCHEMA_NAME>', p_auto_rest_auth =>... Read more
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 second level container can contain multiple Handlers.Handler is logical area where... Read more
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 With Parameters Output Read more
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 INTO l_BLOB FROM APEX_APPLICATION_FILES WHERE filename = 'APEX_ENHANCED_LOV_ITEM.plb'; -- Blob... Read more
$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 Item else false. Syntax: $x('PAGE_ITEM'); $v $v is used to... Read more
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 the item structure <div class="t-Form-fieldContainer t-Form-fieldContainer--floatingLabel lto22054361480113804944_0 apex-item-wrapper apex-item-wrapper--text-field" id="P23_ITEM_CONTAINER">... Read more
Generating JSON using APEX_JSON Sample tables from Oracle Create Two table based on below query and Inserted some record for demo purpose: Sample block to generated JSON manually OUTPUT: References:https://oracle-base.com/articles/misc/apex_json-package-generate-and-parse-json-documents-in-oracle Read more