by: Amr Abdeen
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. sudo add-apt-repository ppa:webupd8team/java...
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...
First execute some codes .. ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS=’DIAGNOSTIC+TUNING’; GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &USER; GRANT advisor to &USER; GRANT administer sql tuning set to &USER; EXEC DBMS_STATS.DELETE_SCHEMA_STATS (‘&USER’); And...
SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: CONNECT SYSTEM/password –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At...
You can by use .. select * from all_constraints where constraint_name = ‘text’
You can alter user by.. sqlplus /nolog connect / as sysdba Once connected, you can change the SYS password to something you know: ALTER USER ADMIN IDENTIFIED BY new_password