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
Ïà¹ØÎĵµ£º
author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌË鯬£¬ÒòΪ´ÅÅÌË鯬»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾºÜ·ÑÁ¦Á˰¡£¬Èç¹ûÔÙÓдóÁ¿
µÄË鯬£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéÆ¬ÒªÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......
Oracle10GµÄEM²ÉÓÃÁËweb·½Ê½£¬²¢ÇÒ·Ö³ÉÁË2¸ö²úÆ·£¬database controlºÍgrid control¡£ÕâÀïÖ÷Òª½éÉÜÈçºÎ´´½¨µ¥Êý¾ÝµÄdbcontrol¡£Grid controlÐèÒªÏÂÔØµ¥¶ÀµÄ¹âÅ̰²×°¡£
ÔÚÓÃDBCA½¨¿âµÄʱºò£¬¿ÉÒÔÑ¡ÔñÊÇ·ñÆôÓÃdbcontrol£¬ÆôÓõϰÐèÒªÔÚ
Êý¾Ý¿â
Öн¨Á¢Ò»¸ösysmanµÄschema£¬ÓÃÓÚ±£´æEMµÄһЩÊý¾Ý£¬Õâ¸ö¾ÍÊÇEMµÄ×ÊÁÏ¿â(reposi ......
select round(sum(case when o.close_date is null then 1 else 0 end)/count(*),3)*100||'%' SCALE from order o
˵Ã÷£ºÊ¹ÓÃsum¶ÔÒ»¶¨Ìõ¼þµÄÊý¾ÝÇóºÍºó£¬Óë×ÜÊý½øÐбȽϡ£
||'%' ΪÒԵİٷֺÅÐÎʽÊä³ö½á¹û(Àý£º2%) ......
CentOS 5.2ÏÂOracle 10G °²×°Ïê½â
2009-01-16 14:38
CentOS ±ØÐèµÄ°²×°°ü
* GNOME Desktop Environment
* Editors
* Graphical Internet
* Text-based Internet
* Development Libraries
* Development Tools
* Legacy Software Development
* Server Configuration Tools
* Administration Tools
* Base
* Le ......