OpenCart Templates
Home / Oracle / SQL


August, 2016

  • 8 August

    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 on ‘IT’ department then open a modal page and when i click on ‘Sales’ department then ...

November, 2015

  • 6 November

    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 i can use SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’) for default value of column    source:

September, 2015

  • 5 September

    How to use the SQL Tuning Advisor feature in Oracle SQL Developer

    First execute some codes .. [crayon-59c52685d7f4e253008176/] And show this toturial to help you link source:

March, 2015