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;
Ïà¹ØÎĵµ£º
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......
2010-04-21 14:04
oracleÖй¹ÔìÊý×éµÄÀý×Ó£º
declare
type t_varray is varray(4) of number;
arr t_varray;
begin
arr := t_varray(1,2,3,4);
for i in 1..arr.count loop
dbms_output.put_line(arr(i));
end loop;
end;
¹¹Ôì¶þάÊý×éµÄÀý×Ó£º
declare
type t_varray ......
»ù±¾µÄSql±àдעÒâÊÂÏî
¾¡Á¿ÉÙÓÃIN²Ù×÷·û£¬»ù±¾ÉÏËùÓеÄIN²Ù×÷·û¶¼¿ÉÒÔÓÃEXISTS´úÌæ¡£
²»ÓÃNOT IN²Ù×÷·û£¬¿ÉÒÔÓÃNOT EXISTS»òÕßÍâÁ¬½Ó+Ìæ´ú¡£
OracleÔÚÖ´ÐÐIN×Ó²éѯʱ£¬Ê×ÏÈÖ´ÐÐ×Ó²éѯ£¬½«²éѯ½á¹û·ÅÈëÁÙʱ±íÔÙÖ´ÐÐÖ÷²éѯ¡£¶øEXISTÔòÊÇÊ×Ïȼì²éÖ÷²éѯ£¬È»ºóÔËÐÐ×Ó²éѯֱµ½ÕÒµ½
µÚÒ»¸öÆ¥ÅäÏî¡£NOT EXISTS±ÈNOT INЧÂÊÉ ......
java¹Ø¼ü×ÖÒÔǰûʲôעÒ⣬ÒòΪÊǺܻù´¡µÄ¶«¶«¡£Ö»ÊǽñÌì×öSCJPÌâÄ¿£¬Ò»¿´´ð°¸ÏÅÎÒ´óÌø£¬·×ªÁËÎÒÒÔÍùµÄ´íÎó¹ÛÄî¡£²éÔÄÁ˲»ÉÙ×ÊÁÏÖÕÓÚŪÇå³þÁË¡£ÌâÄ¿ÈçÏ£º
Which are not Java keywords?
A. TRUE B. sizeof C. const D. super E. void
& ......