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 on ‘IT’ department then open a modal page and when i click on ‘Sales’ department then ...
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 i can use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) for default value of column source: http://apex-oracle-arab.blogspot.com.eg/
First execute some codes .. [crayon-59c52685d7f4e253008176/] And show this toturial to help you link source: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r32/Tuning_Advisor_OBE/SQL%20Tuning%20Advisor.html http://www.dbzoo.com/blog/enabling_oracle_sql_advisor
Next codes help you to audit your app .. Go head… [crayon-59c52685d838e576903968/]
Sometimes you looking for item_ you forget it or not remember whats app include it.. so you use next code to find it…. [crayon-59c52685d87db396411925/] nice day.. 🙂
You can by use .. [crayon-59c52685d8bd9256649452/]
You can alter user by.. [crayon-59c52685d8fd9889381070/]