Oracle Apex: Speed up your APEX
Sometimes i find my Apex is so slow when saving changes after development into Design page, It was from my problems, Now i find cause that it was (Off Gzip compression) into local server configuration like...
Category: Oracle
Oracle Apex: Open multi dialog page from classic report.
Asalamo Alikom .. I have a classic report like department list and i want to link a report column with multiple modal page and its depend on every single department. Like when i click...
Oracle Apex API “$s()”
The Apex JavaScript API has some very convenient functions to access the values of page items. For example, if you wante to access the contents of a text field with JavaScript, would would need...
Solved | Current version of data in database has changed since user initiated update process ERROR.
I faced this problem numerous times in APEX 4.2.6 and I finally got it to work after doing the following: Fix by .. In your query, DO NOT ALIAS any of the update-able columns...
How to cascading single/multi values into tabular form on ORACLE APEX ?
Steps.. Create tabular form, now i want that when changed value OR selected value on cascad_id column i see cascading values into other columns. Change cascad_id type column from number column to Popup LOV (Shows...
Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu/Mint 64-bit
Installing Java We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements. sudo add-apt-repository ppa:webupd8team/java...
code best of #oracle_sql
Case 1 I use COALESCE( v(‘APP_USER’),USER ); instead of NVL( V(‘APP_USER’),USER ); Cause: More performance. Case 2 I use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) instead of V(‘APP_USER’) Cause: i can’t use v(‘APP_USER’) by default value for column but...
How to Run GlassFish V4.1 as a Service on Linux Ubuntu/Debian
source: https://blogs.oracle.com/foo/entry/how_to_run_glassfish_v3 http://computingwithjasper.blogspot.com.eg/2008/01/installing-glassfish-2-on-ubuntu-710.html https://gist.github.com/AmrAbdeen/642183789c0f0ba91613 We already support running GlassFish V3 as a service on Solaris 10 and Windows platforms (see my blog). I have been investigating how to provide support for automatically starting...
How to use the SQL Tuning Advisor feature in Oracle SQL Developer
First execute some codes .. ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS=’DIAGNOSTIC+TUNING’; GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &USER; GRANT advisor to &USER; GRANT administer sql tuning set to &USER; EXEC DBMS_STATS.DELETE_SCHEMA_STATS (‘&USER’); And...
Some audit codes
Next codes help you to audit your app .. Go head… — Find most accessed pages SELECT application_id, application_name, page_id, page_name, SUM (page_id) page_hit_count FROM apex_workspace_activity_log GROUP BY application_id, application_name, page_id, page_name ORDER BY...