ÐÂÊÖÇë½ÌOracleÁ¬½ÓÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí
±¾ÈËÊÇÒ»ÐÂÊÖ¼æ²ËÄñ£¬Ïò¸ßÈËÇë½ÌÏÂADOµÄOracleÁ¬½ÓÎÊÌ⣬лÁË£¡ ǰÆÚ´¦Àí£º import "c:\program files\common files\system\ado\msado15.dll" \ no_namespace \ rename ("EOF", "adoEOF") _ConnectionPtr m_pConnection; ÕâÀïÓ¦¸ÃûÓÐÎÊÌâ°É void COHDCXDlg::ConnectDB() { CoInitialize(NULL); try { m_pConnection.CreateInstance(__uuidof(Connection)); m_pConnection->Open("Provider=OraOLEDB.Oracle.1;Password=manager;User ID=system;Data Source=oradb;Persist Security Info=True","","",adModeUnknown); } catch(_com_error e) { CString errormessage; errormessage.Format("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡\r\n´íÎóÐÅÏ¢£º%s", e.ErrorMessage()); AfxMessageBox(errormessage); } } Ö´ÐкóÀÏÊÇÌáʾ£ºÊý¾Ý¿âÁ¬½Óʧ°Ü£¡ ÎÒµÄÊý¾Ý¿â¾ÍÊÇͨ¹ýsqlplus½¨µÄ¼¸¸ö¼òµ¥±í£¬system£¬manager£¬oradbÊÇsqlplus½çÃæµÇ½ʱµÄÊäÈëÏî¡£ ÁíÍ⣬ÄÜ·ñ¸æÖªOpen()º¯ÊýµÄ²ÎÊý¾ßÌåÖ¸Êý¾Ý¿âÖеÄʲô£¿
ÒýÓà m_pConnection->Open("Provider=OraOLEDB.Oracle.1;Password=manager;User ID=system;Data Source=oradb;Persist Security Info=True","","",adModeUnknown); Password: ÃÜÂë User ID£ºÓû§Ãû Data Source£º¡¡¼àÌýÖеġ¡ µ«ÊÇ£¬system¾ÍÊÇsqlplusµÄÓû§Ãû
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......