AmrAbdeen
11/6/2015 - 6:41 PM

code best of #oracle_sql

code best of #oracle_sql

best_code.txt
content_copyfile_download
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/