BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Oracle / DBA / code best of #oracle_sql

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/

About Amr

Check Also

Oracle APEX | How to add a new row into tabular form by using Hot-Key [JS]

Dear, Now i share sample to using Hot-Keys [JS] to add a new row into ...

Oracle APEX | How to Create Hot-Keys by JavaScript ?

Dear, Now we doing Hot-Keys by JavaScript, Its so sample 🙂 [crayon-59c52878a13c5450598349/] Now Watching & ...