BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Oracle / SQL

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: http://apex-oracle-arab.blogspot.com.eg/

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: 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

March, 2015