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…
Posted inAPEX
Change Font Awesome Icon Color
Most of the times we do not want the default color of font awesome icons. To replace this thing we can use following : Click on page Title , Go…
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…
Posted inOthers
How to Add Subscription to Blogger
Feedburner helps to achieve many things like generating site feed url, email subscription to sites. Go to feedburner . Add your Blogger to feedburner Now get your subscription: click to “Publicize”. and further…
Posted inAPEX
APEX Server Process | apex.server.process | Namespace:server
Namespace:server How to use apex.server.process? Create an ajax callback process then try out process function to call it. Basic syntax (namspace) process(pName, pDataopt, pOptionsopt) → {Promise} Copy CodeCopiedUse a different…
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…
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…
CLOB to BLOB using PLSQL
Create function to convert the CLOB to BLOB Copy CodeCopiedUse a different BrowserCREATE OR REPLACE FUNCTION clob_to_blob (i_clob_text IN CLOB) RETURN BLOB IS /* Version 1 29-mar-2020 */ l_blob_file BLOB;…
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…
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…