Posted inAPEX PLUGINS

Material Cards Region Plugin

Material Cards Region plugin (1.0) | Oracle APEX.   This plugin returns the dynamic material cards with ripple effect. In this plugin everything is customizable, from color to icons and…
March 2, 2020
Posted inAPEX

APEX page types | Universal Theme

APEX provides three types of pages till APEX 20.  To create these pages Select Page Mode. Page ModeSelect the page mode for this page. Available options include: NormalThe page is…
March 1, 2020
Posted inAPEX

Create ZIP File using APEX_ZIP

Data TypesThe data types used by the APEX_ZIP package.t_filestype t_files is table of varchar2(32767) index by binary_integer; Copy CodeCopiedUse a different Browserdeclare l_zip_file blob; begin for l_file in ( select…
February 29, 2020
Posted inAPEX

APEX Page Group

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

BLOB to CLOB using APEX_WEB_SERVICE

BLOB2CLOBBASE64 Function This function is used to convert Blob to base64Clob. Syntax: Copy CodeCopiedUse a different BrowserAPEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB; Example : Copy CodeCopiedUse a different Browserdeclare…
February 29, 2020
Posted inAPEX ORDS

Getting into ORDS

Firstly we need to enable ORDS. Base url : <SERVER_URL>:<SERVER_PORT>/ords/ To hide the schema name from the API endpoint we put any alias in the url mapping pattern. Copy CodeCopiedUse a different…
February 29, 2020