Remove .svn

When we need to remove .svn from each directories in a project (Using Subversion to control code), run following command in Unix/Linux:
$ find . -name .svn -print0 | xargs -0 rm -rf

*Note
using zip to compress file/folder in Unix/Linux

$ zip -r FCH.zip FCH
$ upzip FCH.zip

Jdeveloper and SVN

JDeveloper with svn (Subversion)
http://www.oracle.com/technology/products/jdev/htdocs/partners/addins/exchange/subversion/subversion.html

Sticky Note

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

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




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

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);

Create Procedure

Procedure:
create or replace procedure hello is
begin
DBMS_OUTPUT.PUT_LINE('hello');
end hello;
Call:
SET SERVEROUTPUT ON;
begin
hello;
end;
/