by: Amr Abdeen
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...
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...
SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: CONNECT SYSTEM/password –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At...