Dec 18, 2007

Sticky Note

http://www.greeneclipse.com/stickypad.html

Dec 16, 2007

Change Language in Oracle in Windows

- run
- regedit
-Change value of HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG

NLS_LANG = LANGUAGE_TERRITORY.CHARACTER_SET

English

AMERICAN_AMERICA.WE8MSWIN1252

Japanese

JAPANESE_JAPAN.JA16SJIS



Dec 14, 2007

Change Language in JDeveloper

Change in JDEV_HOME/jdev/bin/jdev.conf
Add following:
AddVMOption -Duser.language=en
AddVMOption -Duser.country=US
or
Modify
AddVMOption -Doracle.translated.locales=en

Dec 6, 2007

Delete duplicate rows in Table - Oracle

delete from TABLE_NAME t1
where t1.rowid >
( select min(t2.rowid) from TABLE_NAME t2
where t1.COLUMN_1 = t2.COLUMN_1
and t1.COLUMN_2 = t2.COLUMN_2);