oracle¼àÌýÆ÷µÄÎÊÌ⣬ÔÚÏßµÈ
ÎÒÔÚ·þÎñÄÜÕý³£µÄÆô¶¯oracle¼àÌý·þÎñ¡£µ«µ±ÎÒ´ò¿ªplsql¹¤¾ß Ñ¡ÔñÊý¾Ý¿â£¬ÊäÈëÃÜÂ룬µÇÈëµ½Êý¾Ý¿âʱ¡£³öÏÖTNSLSNR.EXE - Ó¦ÓóÌÐò´íÎ󡣡£
¿ªÊ¼ÎÒÒÔΪÊÇÎÒµÄC:\WINDOWS\system32\drivers\etc ϵÄhostÎļþ¸Ä¶¯ºóµ¼Öµģ¬ÎÒ°ÑhostÎļþµÄÄÚÈÝ»¹Ôµ½³õʼ״̬£¬½á¹û»¹ÊÇͬÑùµÄ´íÎó
ÏÂÃæÊÇlistener.ora µÄ´úÂ룺
# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = e92b9c44e169443)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORAC)
(ORACLE_HOME = E:\oracle\ora92)
(SID_NAME = ORAC)
)
)
Çë¸ßÊÖ°ïÎÒ·ÖÎöһϣ¬Ð¡µÜÔÚ´Ëл¹ý£¡£¡
ÖØÐÂÆ
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......