oracleÊý¾Ý¿âµ¼ÈëÎÊÌ⣿
ÎÒÏÖÔÚÓÐÁ½¸öÊý¾Ý¿âAºÍB£¬±íÊÇÒ»Öµģ¬BÖеÄijЩ±íµÄ×ֶκÍAÓв»Í¬£¬AÖÐÓÐÊý¾Ý£¬µ«ÊÇB¶¼¿Õ±í£¬ÏÖÔÚÎÒÓÃimp½«AÖеÄÊý¾Ýµ¼ÈëBÖУ¬full=y,µ¼ÈëµÄʱºò·¢ÏÖBÖÐËùÓÐ¿Õ±í¶¼ÔÚ£¬µ«ÊǾÍÊÇûÓÐÊý¾Ý£¬È»ºóÎÒ°ÑBÖеıí ɾÁË£¬ÔÙµ¹ÈëAÖеÄÊý¾Ý¾Í¿ÉÒÔÁË£¬Èç¹û±íÒѾ´æÔÚÏëÍù±íÖе¼ÈëÊý¾Ý£¬Ôõô°ì£¿µ¼ÈëÊý¾ÝµÄʱºòÏàͬ±íÃûµÄ±í½á¹¹ÓвîÒ죬»¹Äܵ¼ÈëÊý¾ÝÂð£¿{{
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
SQL code:
declare
v_deptno number(2);
v_dname varchar2(14);
begin
dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:');
v_deptno:=&deptno;
v_dname:='&dname';
insert into dept01(deptno,dnam ......