ORACLE 模拟 java SPLIT
CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
* 功 能: split.
* 输入参数: Liststr string
* 输入参数: Sepe index
* 输入参数: Sepe separator. default is ','.
* return sepeCount
*/
(
Liststr in varchar2,
inde in number,
Sepe in varchar2 := ','
) return varchar2 is
-- 去掉前后分隔符后的字符串
Str varchar2(4000);
-- 要返回的字符串
retStr varchar2(100);
-- 分隔符个数
sepeCount number(4);
begin
-- 去掉前后的分隔符;
Str := TRIM(BOTH Sepe from Liststr);
sepeCount := f_hps_getsepcount(Liststr, Sepe);
IF sepeCount = 0 THEN
return Liststr;
END IF;
IF inde > sepeCount THEN
retStr := '0';
ELSIF inde = sepeCount THEN
retStr := Substr(str, Instr(str, Sepe, 1, inde) + 1, length(Str));
ELSIF inde = 0 THEN
retStr := Substr(str, 1, Instr(str, Sepe, 1, 1) - 1);
ELSE
str := SubStr(Str, Instr(str, Sepe, 1, inde) + 1, length(str));
retStr := Substr(str, 1, Instr(str, Sepe, 1, 1) - 1);
END IF;
return retStr;
end;
相关文档：
通过 select * from table whereid=16701 for update 锁住一张表
通过以下语句可查询出被锁住的对象
SELECT OBJECT_ID,
SESSION_ID,
SERIAL#,
ORACLE_USERNAME,
&nb ......
CREATE OR REPLACE PROCEDURE kevin_proc(x varchar) IS
a VARCHAR(20);
b VARCHAR(20);
CURSOR mycur(rn NUMBER) IS SELECT * from t_kevin_test WHERE ROWNUM<rn;
BEGIN
OPEN mycur(10);
LOOP FETCH mycur INTO a,b;
EXIT WHEN mycur%NOTFOUND;
Dbms_Output.put_line('a: '||a);
Dbms_Output.put_line('b: '| ......
Oracle的日期函数
常用日期型函数
1。Sysdate 当前日期和时间
SQL> Select sysdate from dual;
SYSDATE
----------
21-6月 -05
2。Last_day 本月最后一天
SQL> Select last_day(sysdate) from dual;
LAST_DAY(S ......
select * from TTable1 for update 锁定表的所有行，只能读不能写
2 select * from TTable1 where pkid = 1 for update 只锁定pkid=1的行
3 select * from Table1 a join Table2 b on a.pkid=b.pkid for update 锁定两个表的所有记录
4 select * from Table1 a join Table2 b on a.pki ......
author：skate
time：2010-05-13
1)If memory increases and you're 64-bit, e.g 8G to 16G, Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration, some parameters, based on CPU_co ......
