oracleɾ³ý±íÊý¾Ýʱ ORA-00907: ȱÉÙÓÒÀ¨ºÅ
sqlÓï¾ä£ºdelete from test.tableA; ¾ÍÌáʾ£ºORA-00907: ȱÉÙÓÒÀ¨ºÅ ÎÒ²»¶®£¬ÎÒÄÄд´íÁË£¿~~
select * from test.tableA; ÊÇʲô½á¹û£¿ testÊÇÄãµÄschema? °ÑÄãµÄsqlÓï¾äÑ¡ÖÐÖ´ÐÐ +1ÒýÓà select * from test.tableA; ÊÇʲô½á¹û£¿ testÊÇÄãµÄschema? Ñ¡ÖÐÕâÌõÓï¾äÖ´ÐÐ..¿´»¹³ö²»³öÏÖ´íÎóÒýÓà sqlÓï¾ä£ºdelete from test.tableA; ¾ÍÌáʾ£ºORA-00907: ȱÉÙÓÒÀ¨ºÅ ¿´²»³ö´íÎ󣡵ȴý´óϺÁË£¡ ";"È¥ÁËÊÔÊÔ Ã»ÓÐ´í¡£¡£¡£ÒýÓà sqlÓï¾ä£ºdelete from test.tableA; ¾ÍÌáʾ£ºORA-00907: ȱÉÙÓÒÀ¨ºÅ ÎÒ²»¶®£¬ÎÒÄÄд´íÁË£¿~~ µ¥Õâ¸öÓï¾äºÃÏñûÓÐÓï·¨´íÎó£¬ ÊDz»ÊÇÏà¹ØµÄÓï¾äÓÐ´í£¬±ÈÈçÕâ¸ö±íÉÏÃæÓÐûÓÐdeleteµÄtriggerѽ¡£Õâ¸ötriggerÀïÓÐÕâÑùµÄ´í¡£ deleteµÄtrigger£¿ºÃÏñûÓÐ ·ÖºÅÊÇÐèÒªµÄ... select µÄʱºòÓÉÓÚÀïÃæÓÐblob×Ö¶ÎʲôµÄ£¬ËüÌáʾ˵ÓÐЩ×Ö¶ÎÎÞ·¨ÏÔʾ£¬Ò²¾ÍÊÇÕâÕűíÊÇ´æÔÚµÄ ¶øÇ񼆮æ¹ÖµÄÊÇ£¬ÎÒǰÁ½Ì컹Óõĺúõ쬽ñÌì¾Í³öÏÖÕâ¸öÎÊÌ⣬ʵÔÚÊÇûÕÞÁË ¶ÔÁË£¬Õâ¸öoracleÊÇoracle9i°æ±¾ÒýÓà ¶ÔÁË£¬Õâ¸öoracleÊÇoracle9i°æ±¾ Ö»Äܹé½áÓÚ°æ±¾ÎÊÌâÁË¡£ÒýÓà ÒýÓà 10 Â¥ casilin µÄ»Ø¸´: ¶ÔÁË£¬Õâ¸öoracleÊÇoracle9i°æ±¾ Ö»Äܹé½áÓÚ°æ±¾ÎÊÌâÁË¡£ ¿ÉÎÊÌâÊÇ£¬ÎÒǰÁ½ÌìÅÜ´úÂ붼û³öÏÖÕ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......