Skip to content

Instantly share code, notes, and snippets.

@AmrAbdeen

AmrAbdeen/best_code.txt

Created November 6, 2015 18:41
Show Gist options
  • Save AmrAbdeen/4939946a0f1661d6be09 to your computer and use it in GitHub Desktop.
Save AmrAbdeen/4939946a0f1661d6be09 to your computer and use it in GitHub Desktop.
Download ZIP
code best of #oracle_sql
Raw
best_code.txt
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/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment