code best of #oracle_sql
Case 1
I use
COALESCE( v(‘APP_USER’),USER );
COALESCE( v(‘APP_USER’),USER );
instead of
NVL( V(‘APP_USER’),USER );
Cause:
More performance.
More performance.
Case 2
I use
SYS_CONTEXT(‘APEX$SESSION’, ‘app_user’)
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
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
![Oracle APEX | How to change theme template to support RTL [Arabic Language]](https://howoracleapex.com/wp-content/themes/hueman/assets/front/img/thumb-medium-empty.png)