¹ØÓÚphp+oracleµÄ¼¸¸öÈëÃÅÎÊÌâ¼°Çó×ÊÁÏ
RT£¬Çë½Ì¼¸¸öphp+oracleµÄÈëÃÅÎÊÌ⣬ϣÍû¸÷λ¸øµã×ÊÁÏ»ò¼òµ¥»Ø´ðÏ¡£
1.±¾µØµÄphpÁ¬½ÓÔ¶³ÌµÄoracle·þÎñÆ÷£¬Ó¦¸ÃÈçºÎÅäÖã¿ËÑÁËЩ»ù±¾¶¼ÊDz¼ÖÃÔÚÒ»ÆðµÄ£¬Á¬½ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µÄ»°Ò²±ØÐëÔÚ±¾µØ×°oracleô£¬ÓÐûʲôÏêϸµãµÄ½Ì³Ì£¿
2.¹ØÓÚoracleºÍmysqlµÄ²»Í¬£¬¶Ômysql±È½ÏÊìϤµÄǰÌáÏÂÏëÒª¾¡¿ìÁ˽âoracle¿´Ð©ÄÄ·½ÃæµÄ½Ì³Ì±È½ÏºÃ£¿£¨±ÈÈç¸ÕÖªµÀoracleûÓÐlimitÕâÖÖÓ÷¨¡£¡£¡££©
3.ÓÐûÓбȽϺÃÓõĿÉÒÔ·ÃÎÊÊý¾Ý¿â·þÎñÆ÷£¬²¢½øÐи÷Àà²Ù×÷µÄ¿Í»§¶ËÈí¼þ£¿±ÈÈçmysqlµÄMySQL-FrontÕâÖÖ£¿
×ÜÖ®ÊÇÁÙʱ±§·ð½ÅµÄÇó¸÷Î»ÍÆ¼öµãÏà¹Ø×ÊÁÏ£¬ÓÐС°×µÄµØ·½Îð¹Ö¡£Ð»Ð»ÁË¡£
php²Ù×÷oracleµÄ·½·¨¿´°ï×éÎĵµ¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
±¾À´ÒªÐ´¸ö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µÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......