oracleÊÂÎñ´¦Àí
1.»ØÍËÊÂÎñ
×îºÃÉèÖÃÒ»¸ö±£´æµã£¬Àýsavepoint a,»òÕßÖ´ÐÐ exec dbms_transaction.savepoint('a')(Ö´ÐÐÇ°ÐèÒªÖ´ÐÐset serveroutput onÓï¾ä)£»È¡Ïû²¿·ÖÊÂÎñ¾Í¿ÉÒÔʹÓÃrollback to a,»òÕßÖ´ÐÐexec dbms_transaction.rollback_savepoint('a');È¡ÏûÈ«²¿ÊÂÎñ¿ÉÒÔÖ´ÐÐrollback,»òÕßexec dbms_transaction.rollback;
2.Ö»¶ÁÊÂÎñ
set transaction read only,»òÕßÖ´ÐÐexec dbms_transaction.read_only;ÕâʱºòÄãÔÙ½øÐвéѯ»Ø²éѯÄãÖ´ÐÐÕâÌõÓï¾äʱ¸Ã±íÖÐÊý¾ÝµÄÐÅÏ¢£¬ÆäËûÓû§ÐÞ¸ÄʱËäÈ»¸Ä±äÁ˱íÖеÄÊý¾Ýµ«ÊDz»»á±»Äã·¢ÏÖ¡£
3.˳ÐòÊÂÎñ
set transaction isolation level serializable;»ù±¾ÉÏÓë2ÌõÖ´ÐÐÒ»Ñù¡£
Ïà¹ØÎĵµ£º
ÔÚlinuxÏÂÆô¶¯oracle ºÍÔÚwindowsÊÇÓвî±ðµÄ£¬¶ÔÓÚÒ»°ãÔÚwindowsϲÙ×÷Ï°¹ßÈËÓкܶ಻ÊÊÓ¦£¬ËùÒÔÎÒÌرðдÕâÑùÎÄÕ£¬ÒÔ·½±ãÐÂÊÖ½øÐвÙ×÷£¬ÏÂÃæ¾ÍÒ»²½Ò»²½½²½âÆô¶¯¹ý³Ì¡£
1.ͨ¹ýÖÕ¶ËÁ¬½Óµ½linux·þÎñÆ÷,µ±È»ÕâÑùµÄÈí¼þºÜ¶àÀýÈçputty,SecureCRT,²¢ÒÔoracleÓû§½øÐеǼ£¬·ñÔòÆô¶¯oracleʱ»á´íµÄ£¬Ã»ÓÐȨÏÞÆô¶¯.(Ò²¿ÉÓû§root µ ......
SQL> select * from ta;
ID NAME
---------- --------------------
1 gorey
2 gorey2
SQL> select * from tb;
I ......
create or replace procedure getok
as
cursor mycur is select ids,name from aaa where name not in (select names from ok);
vempno aaa.ids%type;
vename aaa.name%type;
begin
open mycur;
loop
fetch mycur into vempno,vename;
exit when mycur%notfound;
if mycur%found then
insert ......
Oracl Êý¾Ý¿âҲûÓиö°ë¶Î±íÊÇ·ñ´æÔÚ£¬´æÔÚÔòɾ³ýµÄÓï¾ä£¬¾¹ýÑо¿ºÍ¸ÄдËûÈ˵ķ½·¨ÏÈ¡ÖØÍƳö¾ø¶ÔÄÜÓÃÐÔµÄOracleÅжϱíÊÇ·ñ´æÔÚ£¬´æÔÚÔòɾ³ý·½·¨£¬ÔÚOracle10gÉÏÊÔÑéͨ¹ý¡£
·½·¨
CREATE OR REPLACE FUNCTION PROC_NAME(T_NAME IN VARCHAR2) RETURN NUMBER IS
V_CNT number;
V_SQL VARCHAR2(100);
......
Sample
±í¿Õ¼ä£ºIMPTEMP
±í£ºRoles ¡¢Users
ͨ¹ýPL/SQLµ¼³öµÄÊý¾Ý¿â½Å±¾
-----------------------------------------------------
-- Export file for user IMPTEMP --
-- Created by Administ ......