ORACLE¶àÓû§Ö®¼ä¹²Ïí´æ´¢¹ý³Ì
ÔÚÊý¾Ý¿âÖУ¬ÓÐÁ½¸öÓû§usera£¬userb£¬Èç¹ûÔÚbÖÐÓиö´æ´¢¹ý³Ì£¬ÐèÒªÓÃaµÄÓû§È¥µ÷Ó㬣¨±ÈÈçbÊÇȨÏ޺ܸߵÄÓû§£¬¶øaÖ»ÊÇÆÕͨÓû§£¬ÎªÁËÆÁ±Î¸øa×îСµÄȨÏÞÖ»ÄÜÈç´Ë£©¡£ÓÚÊÇ£¬ÎÒ¾ÍÓÃgrant execute on ´æ´¢¹ý³ÌÃû to usera¡£ÕâÑù£¬ÔÚaµÄÓû§ÏÂÃæ¾ÍÄÜ¿´µ½´æ´¢¹ý³ÌÁË£¬µ«ÊÇÎÒÖ´ÐÐÒԺ󣬻¹ÊDZ¨ora-1031£¬ËµÊÇûÓÐȨÏÞ£¬¾¹ýÓÚ¸ßÊÖ½»Á÷£¬ËµÊÇÐèÒª½«´æ´¢¹ý³ÌÖ®ÖÐÉæ¼°µÄ±íµÄ²éѯȨÏÞ¸³Öµ¸øa¡£ÓÚÊÇÎÒÔٴνøÐи³È¨£¬µ«ÊÇÎҵĴ洢¹ý³ÌÖÐµÄ±í¶¼ÊǶ¯Ì¬Éú³ÉµÄ£¬Ò»ÌìÒ»¸ö£¬¶øÓÖ²»Ïë¸øËûanyµÄȨÏÞ¡£±»±ÆÎÞÄΣ¬ÓÖڤ˼¿àÏ룬·¢ÏÖ´æ´¢¹ý³ÌÄܹ»Õý³£µÄ¼Ç¼ÈÕÖ¾£¬¾ÍÊDzÙ×÷ÈÕÖ¾±í¡£ÓÚÊǵóö½áÂÛ£ºÈç¹û¸øÁíÒ»¸öÓû§¸³È¨ÒԺ󣬵±ËüÖ´Ðд洢¹ý³Ìʱ£¬¾ÍÏ൱ÓÚ´æ´¢¹ý³ÌÔÚ×Ô¼ºµÄÓû§ÏÂÖ´ÐУ¬²»±ØÔÙ¸ø±í¸³È¨ÁË£¬°Ñ¸ßÊֵĽáÂÛÍÆ·ÁË¡£µ«ÊÇΪʲô»¹ÓÐ1031µÄȨÏÞÎÊÌâÄØ£¬¼ÌÐø¸ú×Ù£¡·¢ÏÖÓï¾äexecute immediateÓï¾äÖÐÓÐtruncateÓï¾ä£¬ÐèÒªÇå³ýa²»Óû§µÄ±í¡£¶øbÓû§Ã»ÓÐdrop any table»òÕßaÓû§±íµÄȨÏÞ£¡Õâ´ÎÊÇÕæÕýµÄÎÊÌ⣬ËùÔÚ£¬ÓÚÊǸ³È¨£¬ÎÊÌâOK¡£
½áÂÛ£º´æ´¢¹ý³Ì¸³È¨ÒÔºó£¬Ïà¹ØµÄÈκαíºÍ¹ý³Ì¶¼²»ÓÃÔٴθ³È¨¡£¾ÍÏñÓïÑÔ¶ÔÍâÌṩµÄ·½·¨Ò»Ñù£¡
execute immediate “truncate”Óï¾äÒ»¶¨ÒªÓÐɾ³ý±íµÄȨÏÞ£¡£¡
Ïà¹ØÎĵµ£º
¾³£ÔÚƽʱµÄ¿ª·¢ÖÐÒªÓõ½oracleµÄÈÕÆÚº¯Êý£¬Ã¿´Î¶¼ÒªÉÏÍøÈ¥²é£¬ÏÖÔÚÓеãʱ¼ä£¬×Ô¼ºÊÕ¼¯ÕûÀíÁËһϡ£ÌùÔÚÕâÀ·½±ã×Ô¼º£¬Ò²·½±ã´ó¼Ò¡£
----------------------------------------------------------------------------------------------------------------------------------
³£ÓÃÈÕÆÚÐͺ¯Êý
1¡£Sysdate µ±Ç°È ......
Ò»¡¢Êý¾Ý¿âµÄÏà¹Ø¸ÅÄî
Êý¾Ý¿â£¨DB£©ÊÇÒ»¸ö°´Êý¾Ý½á¹¹À´´æ´¢ºÍ¹ÜÀíÊý¾ÝµÄ¼ÆËã»úÈí¼þϵͳ¡£
1¡¢Êý¾Ý¿â¹ÜÀíϵͳÓëÊý¾Ý¿âÓ¦ÓÃϵͳ
(1)Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨DBMS£©ÊÇרÃÅÓÃÓÚ¹ÜÀíÊý¾Ý¿âµÄ¼ÆËã»úϵͳÈí¼þ¡£Êý¾Ý¿â¹ÜÀíϵͳÄܹ»ÎªÊý¾Ý¿âÌṩÊý¾ÝµÄ¶¨Òå¡¢½¨Á¢¡¢Î¬»¤¡¢²éѯºÍͳ¼ÆµÈ²Ù ......
<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......
½ñÌì¼ÌÐøÊÔÑéÊ®·ÖÖÓ¿ÉÒÔ¸Éʲô£¬Ñ¡È¡Á˶ÔOracleË÷ÒýµÄ½éÉÜ£¬½á¹ûÈçÏ£º
´ÓgoogleÉÏÑ°ÕÒ×ÊÁÏ£º1:15Ãë¡£
ÔĶÁ¸ÅÊö²¿·Ö£º3:15Ãë¡£
OracleµÄË÷ÒýÖ÷Òª°üº¬Á½ÀࣺBTreeºÍλͼË÷Òý¡£Ä¬ÈÏÇé¿öÏ´ó¶àʹÓÃBtreeË÷Òý£¬¸ÃË÷Òý¾ÍÊÇͨ³£Ëù¼û ΨһË÷Òý¡¢¾Û´ØË÷ÒýµÈµÈ£¬BtreeÓÃÔÚOLTP£¬¼Ó¿ì²éѯËٶȡ£Î»Í¼Ë÷ÒýÊÇOracleµÄ±È½ÏÒýÈËעĿµÄµØ ......
--------------------ÏÔʽÓαê
--²éѯÊý¾Ý
select * from employees;
--¶¨Ò岿·Ö
declare
--ÉùÃ÷Óαê
cursor mycur is select * from employees where employee_id<120;
--¶¨ÒåÒ»¸ö¼¯ºÏ±äÁ¿ÓÃÓ ......