ORACLEÁ¬½Ó·½·¨ - VC/MFC / Êý¾Ý¿â
ÈçÏÂVC6²Ù×÷ORACLEÁ¬½Ó·½·¨Îª¿É±¨´í£º
_bstr_t connStr£»
connStr="Provider=OraOLEDB.Oracle;User ID=scott;Password=tiger;Data Source=192.168.0.120;";
m_SqlConn->Open(_bstr_t(connStr),(_bstr_t)_T(""),(_bstr_t)_T(""),adConnectUnspecified);
˵Ã÷£º
ÎҵĻú×ÓIPÊÇ192.168.0.120£¬ÎÒÏë×Ô¼ºÁ¬×Ô¼º£¬ÔÚÎҵı¾µØµçÄÔÖÐ×°ÁËORACLE£¬Ã»×°¿Í»§¶Ë¡£
ÕâÑùÁ¬½ÓÊÇ´íÎóµÄ¡£
ÏÖ¸ÄΪ
Data Source=Êý¾Ý¿âÃû; ¼´¿ÉÁ¬½Ó³É¹¦¡£ÇëÎʼÙÈçÎÒÒªÁ¬½Ó¾ÖÓòÍøÖеÄһ̨·þÎñÆ÷£¬¶øÎÒ×Ô¼ºµÄµçÄÔ×÷
¿Í»§¶Ë£¬ÇëÎʿͻ§¶ËÕâ±ßÒªÔõô×ö£¿
Á¬½ÓµÄ·½Ê½ÊÇÄÄÖÖ£¿{{
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......