¹ØÓÚoracle ÔËÐÐ
°²×°µÄ°æ±¾ÊÇ11g,°²×°Êdzɹ¦µÄ¡£¿ÉÊÇÆô¶¯SQL Developer³öÏÖÌîдjava.exeµÄ·¾¶´°¿Ú¡£×Ô¼º¾õµÃÊÇjdkÀïµÄjava.exe¿É»¹ÊÇ¿´²»µ½Êý¾Ý¿â½çÃæ. Çë¸÷λǰ±²ÃÇÖ¸½Ì Ìá³ö½â¾ö·½°¸£¡£¡(±¾È˵Ļú×ÓϵͳÊÇVISTA)
´íÎóÌáʾÊÇʲô,ÎÒÓÃ×Ô´øµÄjava.exeûÓÐÎÊÌâ
¿ÉÒÔÈ¥ÏÂÔØ×îеÄjava
ºÃÏóÓÐÒ»¸ö°æ±¾µÄdeveloperÊÇ×Ô´øµÄjava
SQL DeveloperûÓùý
½¨ÒéÄãʹÓÃplsql developer°É
¶¼ÓÃÁË£¬»¹ÊDz»ÐÐ!!²»ÊÇ×Ô´øµÄÊǾ¯¸æ£¬oracle°²×°µÄJDKÀïÖ±½Óµ¯»ØÌîÈë·¾¶´°¿Ú£¡
ÎÒµÄjave.exeÎÒÊÇÑ¡µÄ \sqldeveloper\jdk\jre\bin\java.exe
ʹÓÃûÓÐÎÊÌâ
Õæ²»ÐÐ,Äã¾ÍÈçÂ¥ÉÏËù˵ÓÃplsql developerºÃÁË
ÄǸö¸üÇá±ã,Ò²Óйٷ½ºº»¯°ü
ÕâÊǹÙÍøµÄµØÖ·
http://www.allroundautomations.com/
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¿ª·¢¹¤¾ßÊÇC#£¬Ð´µÄC/SģʽµÄ³ÌÐòʹÓÃORACLE OleDbµÄ·½Ê½Á¬½Óoracle 10GÊý¾Ý¿â£¬Õý³£²Ù×÷ûÎÊÌ⣬ֻҪһ·ÖÖÓ²»²Ù×÷£¬È»ºóÓ¦ÓóÌÐò¼ÌÐø¶ÔÊý¾Ý¿â²Ù×÷¾Í»á±¨³ö¡°Ã»ÓпÉÓõĴíÎóÐÅÏ¢£¬´íÎó´úÂ룺E_FAIL(0x80004005)¡±£¬Ê ......