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°æ±¾ Ö»Äܹé½áÓÚ°æ±¾ÎÊÌâÁË¡£ ¿ÉÎÊÌâÊÇ£¬ÎÒǰÁ½ÌìÅÜ´úÂ붼û³öÏÖÕ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......