DelphiÈçºÎÓëoracleÁ¬½Ó
ÒÔǰһֱÓõÄÊÇSQL SERVER
µ½Á˵¥Î»£¬Êý¾Ý¿âÓõÄÊÇoracle£¬ÍøÉÏ¿´ÁËЩÌû×Ó£¬»¹ÊÇÓÐЩ²»Ã÷²»°×£¬ÄÄλÓÐÏêϸµãµÄ²½ÖèµÄ
¶Ë¿Ú1521 IPÊÇ192.168.0.1¾ÙÀýÈç´Ë£¬ÔõôÁ¬½Ó¡£
Ò»°ãÐèÒªÏȰ²×°oracle¿Í»§¶Ë,¸ù¾ÝÇé¿ö,¿ÉÒÔÑ¡ÔñÐÔµÄ×°oracleµÄodbc/oledbÇý¶¯
Ò»°ãÇé¿öÏÂÒªÏÈ×°Oracle¿Í»§¶Ë²ÅÄÜÁ¬¡£ÓÃADO£¬DBX¶¼ÄÜÁ¬£¬²»¹ýÎÒ¶¼ÊÇÓÃODACµÄ£¬»òÕßDAO(Direct Oracle Access)
¿Í»§¶ËÒѾ°²×°ÁË net manager Ò²ÅäÖùýÁË
Ö»Êǵ¥´¿µÄ¶ÔÓÚoracle²»ÊìϤ ºÜ¶àϸ½ÚÎÊÌâ¶¼»¹Ã»¸ãÇå³þ
Oracle¾ÍÊDZȽÏÂ鷳Щ
¶øÇÒÓÃBDE²é´óÁ¿Êý¾Ýʱ»áºÜ¿ì
Êý¾ÝÁ¿Ì«´ó ÊDz»ÊÇ¿ÉÒÔ¿¼ÂÇд¸öË÷Òý
°²×°¸ö¿Í»§¶Ë£¬ÅäÖøöÊý¾ÝÔ´£¬È»ºóADOÁ¬½Ó¾Í¿ÉÒÔÁË£¬ºÍÁ¬SQLServer²î²»¶à°Ñ
oracleºÍSQL ÓÐÇø±ðµÄ Êý¾ÝÔ´ÄÇÀïÎÒ²»»áÅäÖÃ
°´5Â¥µÄ˵·¨ ÎÒÅäÖÃÁ˼àÌý ½¨Á¢ÁËÒ»¸ö²âÊÔ¿â ×Ô¼ºÏÈÊÔÊÔÁË~
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ³£ÉÏÀ´×ª×ªµÄ
ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔÒò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......