Connecting to Oracle 10G, when you have Oracle 11G Installed in your PC

When you want to connect to Oracle 10G,  when you have Oracle 11G already Installed in your PC...  you will get something like whut the hell i cannot connect to 10G now? the trick is... the Environment Path in windows will set the pirority to 11G so your 10G will be left out and get rotten suck. to solve it... just alter the environment  and set the path again so 10G is the first pirority : C:\oracle\product\10.2.0\client_1\bin;c:\app\product\11.2.0\dbhome_1\bin; how...

oracle timestamp tak sama dengan sysdate

jika anda select CURRENT_TIMESTAMP  dan tak sama dengan SYSDATE, maknanya setting time zone tak betul. untuk betulkan sila run berikut ( kl adalah minus 8, bukan plus 8 la ok dalam oracle nie ):          ALTER SESSION SET TIME_ZONE = '-8:0'; dah select semula disini :          SELECT CURRENT_TIMESTAMP, SYSTIMESTAMP, sysdate FROM DUAL;     haaa... kan dah sama... terbaekk...

Oracle Wrapping / Obfuscating

The advantages of obfuscating, or hiding, the source code of PL/SQL units with the wrap utility or wrap subprograms of the DBMS_DDL package are: It is difficult for other developers to misuse your application, or business competitors to see your algorithms. Your source code is not visible through the USER_SOURCE, ALL_SOURCE, or DBA_SOURCE data dictionary views. SQL*Plus can process the obfuscated source...