Reset oracle sequence procedure

Oracle sequence cannot reset by command , need workaround to achieve original start value.

CREATE OR REPLACE PROCEDURE reset_sequence (
seq_name IN VARCHAR2) AS
cval INTEGER;
inc_by VARCHAR2(30);
BEGIN
EXECUTE IMMEDIATE 'ALTER SEQUENCE ' ||seq_name||' MINVALUE 0';
EXECUTE IMMEDIATE 'SELECT ' ||seq_name ||'.NEXTVAL FROM dual' INTO cval;
IF cval < 0 THEN
inc_by := ' INCREMENT BY ';
cval:= ABS(cval);
ELSE
inc_by := ' INCREMENT BY -';
END IF;
EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || seq_name || inc_by || cval;
EXECUTE IMMEDIATE 'SELECT ' ||seq_name ||'.NEXTVAL FROM dual' INTO cval;
EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || seq_name || ' INCREMENT BY 1';
END reset_sequence;
/

jxl 中文 亂碼 解決

使用 jxl 操作 excel , 當 java code 中的字串值是中文時,遭遇到亂碼狀況,從資料庫取出並寫到Excel 中的資料值是正常中文顯示, 從網路上的解決方式測試也無法解決.
----
WorkbookSettings wbsettings = new WorkbookSettings();
wbsettings.setEncoding("ISO-8859-1");

jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os,wbsettings); //建立Excel

----

Solution:
Compile java code use "javac -encoding BIG5 xxx.java" , 可解決.

Movie list

1. 為愛朗讀 - good
2. 暮光之城 - good
3. 吹動大麥的風(風吹稻浪) - not yet
4. 史前一萬年10000 B.C - not yet
5. 功夫之王 - not yet
6. 瓦力 - not Yet
7. 神鬼第六感 - not yet
8. 魔幻時刻 - not yet
9. 黑暗騎士 - not yet
10. 險路勿近 - not yet
11. 地獄魔咒 - good
12. 七級公務員(韓片) - not yet

Apply patcheset Oracle 10.2.0.4 on AIX 6.1

--When apply 10.2.0.4 on AIX 6.1 , failed with "Java process exist" message and apply process stop.
--Workground
As root:
1) rename /usr/sbin/fuser
2) touch /usr/sbin/fuser
3) chmod +x /usr/sbin/fuser
As oracle software owner:
1) Try to install the patchset (or base release)
(fuser can now return nothing, hence the Installer should continue)
After successful install, as root:
1) rename renamed_fuser back to its original name

select view and function throufh db link

select view and function throufh db link.

get_entryvalue is a function in remote DB.

-----------
SELECT ip3.ID,
ip3.CLASS,
ip3.subclass,
ip3.item_number,
ip3.description,
ip3.list32,
ip3.list33,
A.get_entryvalue@A_DB_LINK (ip3.list32) type,
A.get_entryvalue@A_DB_LINK (ip3.list33) group
FROM A.item_p3@A_DB_LINK ip3
WHERE subclass = '123456'

Toad - trouble shoot

1. Open toad very slow.
View -> Options -> Editors (General) , unchecked "Syntax highlighting".
2. Cannot use keyboard "delete","Backspace" in Toad SQL Editor.
Close Toad , delete "plsqlkeys.bin" from "\User Files" directory , then open Toad.