oracle´æ´¢¹ý³Ì
create or replace procedure inserttestdata
(
v_count in number,
v_startuserid in varchar2,
v_returnval out number )
as
v_opertime varchar2(20);
v_current_count number(10);
v_temp_userid varchar2(20);
begin
v_opertime := to_char(sysdate,'yyyy.mm.dd');
v_current_count := 0;
v_temp_userid := v_startuserid;
while 1=1 loop
savepoint begin_tran;
begin
insert into ardinf(userid ,opertime)
values(v_temp_userid ,v_opertime);
exception
when others then
begin
rollback to savepoint begin_tran;
DBMS_OUTPUT.PUT_LINE('exception!');
DBMS_OUTPUT.PUT_LINE(v_temp_userid);
v_returnval := 1008;
exit;
--exitÖ®ºóµÄ´úÂëÎÞ·¨Ö´ÐÐ
DBMS_OUTPUT.PUT_LINE('After exit!Before return');
DBMS_OUTPUT.PUT_LINE(v_returnval);
return;
DBMS_OUTPUT.PUT_LINE(v_returnval);
end;
end;
if v_current_
Ïà¹ØÎĵµ£º
SQL> DESC TEST ²âÊÔ±í: Name Type Nullable Default Comments
---- ------------ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......
Ò»¡¢ Êý¾Ý¿â ORACLE
ËäÈ»ÕâЩÌâÄ¿¶¼¿ÉÒÔGµ½£¬µ«»¹ÊÇÒª¿¼²ìÒ»ÏÂÄúÏÖÔڵij£Ì¬Ë®Æ½£¬£º£©
T±í£º£¨×ֶΣºID£¬NAME£¬ADDRESS£¬PHONE£¬LOGDATE£©
E±í£º£¨×ֶΣºNAME£¬ADDRESS£¬PHONE£©
1£® ½«±íTÖеÄ×Ö¶ÎLOGDATEÖÐΪ2001-02-11µÄÊý¾Ý¸üÐÂΪ2003-01-01£¬Çëд³öÏàÓ¦µÄSQLÓï¾ä¡££¨¸Ã×Ö¶ÎÀàÐÍΪÈÕÆÚÀàÐÍ£©
2£® Çëд³ö½«±íTÖÐNAME ......
SDO_FILTER
¸ñʽ£º
SDO_FILTER(geometry1, geometry2, params);
ÃèÊö£º
ͨ¹ý¿Õ¼äË÷Òý£¬¸ù¾Ý¸ø¶¨µÄ¼¸ºÎÒªËØ¼ìË÷³ö¾ßÓпռäÏ໥¹ØÏµµÄ¿Õ¼ä¶ÔÏó¡£ÕâÀïµÄ¿Õ¼ä¹ØÏµÊÇÖ¸Á½¸ö¼¸ºÎ²»·ÖÀ룬¼´Non-disjoint¡£¡¾disjoint£º±íʾÁ½¸ö¼¸ºÎµÄ±ßºÍÄÚ²¿¶¼²»Ïཻ¡¿
Õâ¸öSdo_Fi ......
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 ......