Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÐÂÊÖÇë½Ì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 webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ