Oracle Apex Tips & Tricks

How to change app icon in oracle apex Login to your workspace Go to application Go to shared components static application files  upload your app-icon png or svg download app-icon.css file and change app icon url to your png uploaded image. Add caption

School management system in oracle apex. view application here :  https://apex.oracle.com/pls/apex/f?p=104825:10::::::

FTP integration in oracle apex 1. FTP Grants Required BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( ACL => 'ftp.xml', DESCRIPTION => 'Network Access Control for HRDEPT', PRINCIPAL => 'HRDEPT',-- Schema name in which app is installed IS_GRANT => TRUE, PRIVILEGE => 'connect'); END; / -------------------------------------------------------------------------------- BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE ( ACL => 'ftp.xml', PRINCIPAL => 'HRDEPT', IS_GRANT => TRUE, PRIVILEGE => 'connect', POSITION => NULL); DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE ( ACL => 'ftp.xml', PRINCIPAL => 'APEX_050100', IS_GRANT => TRUE, PRIVILEGE => 'connect', POSITION => NULL); DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE( ACL => 'ftp.xml', PRINCIPAL =>

Step 1: Create a page item & select type as a number field. Step 2: Under page item settings scroll down to pre & post text. PreText :  <button class="ui-datepicker-trigger a-Button a-Button--calendar"  id="minusButton45act" type="button" title="Remove" aria-label="Remove"><span class="t-Icon fa fa-minus-square" aria-hidden="true"></span></button> Post Text :  <button class="ui-datepicker-trigger a-Button a-Button--calendar"  id="plusButton45act" type="button" title="Add" aria-label="Add"><span class="t-Icon fa fa-plus-square" aria-hidden="true"></span></button> Step 3: Add below CSS code in the page inline CSS. CSS Properties :  #minusButton45act{     border-radius: 3px 0 0 3px;     margin-right: -1px;     color: red; } #plusButton45act {     border-radius: 0 3px 3px 0;     color: green; } Sa

Subtracting two date values in Oracle results in number of DAYS. Therefore, you'd have to do some math in order to get hours (or minutes). Here's an example: col diff_days format 90 D00000 col diff_hours format 90 D00000 col diff_minutes format 90 D00000 with test as ( select to_date ( '29.12.2017 16:05' , 'dd.mm.yyyy hh24:mi' ) d_order , to_date ( '29.12.2017 16:39' , 'dd.mm.yyyy hh24:mi' ) d_now from dual ) select d_now - d_order diff_days , ( d_now - d_order ) * 24 diff_hours , ( d_now - d_Order ) * ( 24 * 60 ) diff_minutes from test ; OUTPUT DIFF_DAYS DIFF_HOURS DIFF_MINUTES --------- ---------- ------------ 0 , 02361 0 , 56667 34 , 00000

Login to your database as a dba & run the below code. BEGIN   DBMS_NETWORK_ACL_ADMIN.append_host_ace (     host       => 'api.docparser.com',     lower_port => NULL ,     upper_port => NULL ,     ace        => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),                               principal_name => ' YOURSCHEMA_USERNAME ',                               principal_type => xs_acl.ptype_db)); END;