Installing Java We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements. [crayon-59c527ab032d3074336266/] Notice:: You can change version from “oracle-java7-installer” to “oracle-java6-installer” or “oracle-java8-installer” .. as you want 🙂 The screen in figure ...
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/
First execute some codes .. [crayon-59c527ab055b8897261734/] And show this toturial to help you link source: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r32/Tuning_Advisor_OBE/SQL%20Tuning%20Advisor.html http://www.dbzoo.com/blog/enabling_oracle_sql_advisor
SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: [crayon-59c527ab059ed956327317/] –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At the SQL Command Line prompt, enter the following command: [crayon-59c527ab059fa964507800/] –where nnnn represents the new port number ...
You can by use .. [crayon-59c527ab05e8e950342188/]
You can alter user by.. [crayon-59c527ab06286322957506/]