Oracle±à³Ì³£¼û´íÎóºÍ·ÖÎö
1. ×ÊÔ´Õýæ´íÎó
ÔÚpl/sql developer¿ªÒ»¸ösql window,Ö´ÐÐÈçÏÂsql²»Ìá½»
Create Table aa(a Int);
Insert Into aa Values(234);
ÔÙ¿ªÒ»¸ösqlwindowÖ´ÐÐ
Drop Table aa
¾Í»á±¨ora-00054´íÎó¡£
OracleËøµÄ֪ʶ£º
´ËʱOracleÒѾ¶Ô·µ»ØµÄ½á¹û¼¯ÉϼÓÁËÅÅËüµÄÐм¶Ëø£¬ËùÓÐÆäËû¶ÔÕâЩÊý¾Ý½øÐеÄÐ޸Ļòɾ³ý²Ù×÷¶¼±ØÐëµÈ´ýÕâ¸öËøµÄÊÍ·Å£¬²úÉúµÄÍâÔÚÏÖÏó¾ÍÊÇÆäËûµÄ²Ù×÷½«·¢Éú×èÈû£¬Õâ¸öÕâ¸ö²Ù×÷commit»òrollback.
ͬÑùÕâ¸ö²éѯµÄÊÂÎñ½«»á¶Ô¸Ã±í¼Ó±í¼¶Ëø£¬²»ÔÊÐí¶Ô¸Ã±íµÄÈκÎddl²Ù×÷£¬·ñÔò½«»á±¨³öora-00054´íÎó£º:resource busy and acquire with nowait specified.
ÒòΪDDLÓï¾äÐèÒª±íÉϵÄÅÅËûËø,¶øÕâÓëDMLÓï¾äÒÑÔÚ±íÉÏ·ÅÖÃÁ˹²ÏíËøÏà³åÍ»,ËùÒÔÊÔͼÔÚ±íÖвåÈëÒ»¸öÁеÄÕâÌõDDLÓï¾ä»áʧ°Ü.ÐèҪעÒâµÄÊÇ:ÔÚÀàËÆÇé¿öÏÂ,DMLÓï¾ä»áµÈ´ý²¢²»¶Ï½øÐг¢ÊÔ,Ö±ÖÁ»ñµÃÆäËùÐèµÄËø(»»¾ä»°Ëµ¾ÍÊÇ¹ÒÆð);¶øDDLÓï¾äÔò»áÓÉÓÚ´íÎóÁ¢¼´ÖÕÖ¹.
ejb BllRequireNewTransÔÚejb-jar.xml±»ÅäÖÃΪÐèÒªÒ»¸öÐÂÊÂÎñ£¬ËùÒÔµ÷ÓôËejb·½·¨µÄÊÂÎñºÍBllRequireNewTrans²»ÔÚÒ»¸öÊÂÎñÖÐ,²»×¢Òâ¾Í»áÒý·¢ÉÏÃæµÄ´íÎó¡£
<container-transaction>
<method>
<ejb-name>BllRequireNewTrans</ejb-name>
<method-intf>Remote</method-intf>
<method-name>*</method-name>
</method>
<trans-attribute>RequiresNew</trans-attribute>
</container-transaction>
</assembly-descriptor>
2. ×ֶα»È«²¿ÖÿյĴíÎó
Create Table bb(a Int, b Int, c Int)
Insert Into bb Values(1,2,3)
Insert Into bb Values(3,2,3)
Insert Into bb Values(4,5,6)
Create Table cc(a Int, b Int, c Int);
Insert Into cc Values(1,20,30
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌË鯬£¬ÒòΪ´ÅÅÌË鯬»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾºÜ·ÑÁ¦Á˰¡£¬Èç¹ûÔÙÓдóÁ¿
µÄË鯬£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéÆ¬ÒªÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......
¼Ç¼һÏÂÒÔ±¸Ï´οìËÙÕÒµ½¡£¡£¡£
Íùtb_wf_privgrant±íÖвåÈëÒ»Ìõ¼Ç¼£¬workflow_id×Ö¶ÎÖµ´Ótb_wf_workflow ±íÖлñÈ¡workflow_name='֪ʶÉóºË'µÄËùÓмǼÖÐworkflow_id×î´óÖµ¡£
--oracle
declare a NUMBER(10);
begin
select max(wo ......
²é¿´Êý¾Ý»µ¿éËùÔÚÊý¾ÝÎļþºÅ¼°¿éºÅ¿ÉÒÔ¶Ô±í½øÐÐÒ»´ÎÈ«±íɨÃ裬È磺
¡¡¡¡select count(*) from tablename;
¡¡¡¡1¡¢Ã»Óб¸·ÝµÄÇé¿öÏ£º
¡¡¡¡1.1¡¢Ê¹ÓÃexp/imp»Ö¸´
¡¡¡¡ÔÚÕâÖÖÇé¿öÏ¿϶¨»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£¬ÔÚÕâÖÖÇé¿öÏÂÓ¦²ÉÈ¡½«Êý¾Ýµ¼³öÈ»ºóÖØ½¨±íÔÙ½øÐе¼ÈëµÄ·½·¨£¬À´¾¡Á¿»Ö¸´Ëð»µÊý¾Ý¿éÖеÄÊý¾Ý£¬µ«ÊÇÔÚÓлµ¿éµÄÇé¿öÏÂ
......