Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí
Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí:
rhel4-1->crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.demo.db application ONLINE UNKNOWN rhel4-2
ora....o1.inst application ONLINE ONLINE rhel4-1
ora....o2.inst application ONLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rhel4-1
ora....-1.lsnr application ONLINE ONLINE rhel4-1
ora....4-1.gsd application ONLINE ONLINE rhel4-1
ora....4-1.ons application ONLINE ONLINE rhel4-1
ora....4-1.vip application ONLINE ONLINE rhel4-1
ora....SM2.asm application ONLINE UNKNOWN rhel4-2
ora....-2.lsnr application ONLINE UNKNOWN rhel4-2
ora....4-2.gsd application ONLINE UNKNOWN rhel4-2
ora....4-2.ons application ONLINE UNKNOWN rhel4-2
ora....4-2.vip application ONLINE ONLINE&
Ïà¹ØÎĵµ£º
¡¾ÑµÁ·6.1¡¿¡¡Ê¹ÓÃÒþʽÓαêµÄÊôÐÔ£¬Åж϶ԹÍÔ±¹¤×ʵÄÐÞ¸ÄÊÇ·ñ³É¹¦¡£
²½Öè1£ºÊäÈëºÍÔËÐÐÒÔϳÌÐò£º
BEGIN
UPDATE emp SET sal=sal+100 WHERE empno=1234;
IF SQL%FOUND THEN
DBMS_OUTPUT.PUT_LINE('³É¹¦Ð޸ĹÍÔ±¹¤×Ê£¡');
......
•ºÎΪÉó¼Æ
Êý¾Ý¿âÉó¼Æ£¬¾ÍÊǶÔÊý¾Ý¿âµÄ»î¶¯×ö¸ú×ټǼ£¬Ö÷Òª°üÀ¨Êý¾Ý¿âÁ¬½Ó£¬SQLÓï¾äÖ´ÐУ¬Êý¾Ý¿â¶ÔÏó·ÃÎÊÕâЩ·½ÃæµÄ¸ú×ټǼ¡£
•ÏÖʵ×÷ÓÃ
°²È«¿ØÖÆ¡¢¸ú×ÙÊý¾Ý±ä»¯¡¢³ÌÐòBUGµ÷ÊÔ¡¢×Ô¶¨ÒåµÄÊý¾Ý»ã×Ü·ÖÎö¡¢²Ù×÷ÈÕÖ¾
•´æ´¢·½Ê½
Ò»ÖÖÊÇ´æ´¢ÔÚ²Ù×÷ϵͳÎļþÖУ¬Ò»ÖÖÊÇ´æ´¢ÔÚsystem±í¿Õ¼äÖеÄSYS.AUD$±íÖÐ
......
ÔÚѧϰoracleµÄʱºòÓöµ½ÁËÒ»¸öÎÊÌ⣬µ±ÎҵǼscottÓû§µÄʱºòÔõô¾ÍÊÇÁ´½Ó²»ÉÏ£¬³öÏÖÁËÒÔÏ´íÎóÌáʾ£¬the account is locked,˵Ã÷scottÓû§±»ËøסÁË£¬ÎҾͽøÐÐÁ˽âËø£¬Óï¾äÈçÏ£ºalter user soctt account unlock;Ö´ÐÐÍêÒÔºó·¢ÏÖÓÖÌáʾÁËÒ»¸ö´íÎóÐÅÏ¢£¬No Connect
ÎÞ·¨Á´½Ó£¬ºóÀ´ÔÚÍøÉϲéÁ˲飬ÖÕÓÚÕÒµ ......
36.ADD_MONTHS
¡¡¡¡Ôö¼Ó»ò¼õÈ¥Ô·Ý
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡200002
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),-2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡199910
¡¡¡¡37.LAST_DAY
¡¡¡¡·µ» ......