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

PL/SQL

January, 2016

  • 13 January

    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 return value) and insert your LOV query . Now looking for ID for cascad_id column by ...

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/

March, 2015

  • 28 March

    How to change port listner in oracle ?

    SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: [crayon-59c526d960da0306949098/] –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At the SQL Command Line prompt, enter the following command: [crayon-59c526d960dad339751641/] –where nnnn represents the new port number ...