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

WINFORM+Oracle¿Í»§¶Ë²¼Êð

×¢£ºÏÂÃæÖ»ÊÇÎÒ´ÖÁӵļǼһÏ£¬×Ô¼ºÔÚ¿ª·¢ÖÐËùѧµÄÒ»²¿·Ö×ÊÁÏ£¡
1£®  µÚÒ»¡¢ÊÇÏÂÔØÒ»¸ö“Oracle9i¿Í»§¶Ë¾«¼ò°æ.exe”¿Í»§¶Ë£¬È»ºó°ÑËü°²×°µ½CÅÌÏÂÃæ¡£
È»ºó°ÑÎÒÃÇ×Ô¼ºÅäÖúõĔ tnsnames.ora”Îļþ£¬¸´¸ÇC:\oracle\ora90\network\adminÏÂÃæµÄtnsnames.oraÎļþ¡£
2£®  ÔÚVS2005¿ª·¢¹¤¾ßÖÐ,Ìí¼Ó²¼ÊðÏîÄ¿£¬¾Ù×ÓÃûΪ£ºreportOrace,µ±ÆäËû°²×°²½Ö趼ÒѾ­×öºÃÁË£¬¾Í²îÌí¼ÓOracle¿Í»§¶Ë¡£ÕâʱºòÎÒÃÇÓÒ»÷²¼ÊðÏîÄ¿£¬Èçͼ
3£®  ÔÚ“Îļþϵͳ”ÖÐÌí¼ÓOracle¿Í»§¶Ë,°ÑÒѾ­°²×°ºÃµÄOracle¿Í»§¶ËÏÂÃæµÄËùÓÐÎļþƽºÍÎļþ½á¹¹¶¼Ìí¼Óµ½²¼ÊðÏîÄ¿µ±ÖС£ÈçÏÂͼ
ÆäÖУ¬Òª×¢ÒâµÄÊÇ£ºOraOLEDBzhs.dll¡¢OraOLEDButl.dll¡¢OraOLEDBus.dll¡¢OraOLEDBpus.dllµÄÊôÐÔRegister¸ÄΪ“vsdrfCOMRelativePath”·ñÔò»áÌáʾ“δÄÜ×¢²áÄ£¿é ….”¡£
4. ÔÙ½øÒ»²½£¬ÎÒÃÇ´ò¿ªÏµÍ³µÄ×¢²á±ícmd->regedit¡£·Ö±ðÕÒµ½
1.) HKEY_CLASSES_ROOT\CLSID\{3F63C36E-51A3-11D2-BB7D-00C04FA30080}
2). HKEY_CLASSES_ROOT\CLSID\{3FC8E6E4-53FF-11D2-BB7D-00C04FA30080}
3). HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup.1
4). HKEY_CLASSES_ROOT\OraOLEDB.ErrorLookup
5). HKEY_CLASSES_ROOT\OraOLEDB.Oracle.1
6). HKEY_CLASSES_ROOT\OraOLEDB.Oracle
7). HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
°ÑÉÏÃæ7¸ö×¢²á±íÑ¡Ïîµ¼³öµ½±¾µØ£»*.reg
5.ÏÖÔÚÎÒÃÇÔÚÀ´£¬ÓÒ»÷²¼ÊðÏîÄ¿£¬“ÊÓͼ”-“×¢²á±í”£¬Èçͼ£º
Ñ¡ÔñÎÒÃǸղŵ¼³öµÄ×¢²á±íÎļþ
×îºó»¹ÒªÒªÐÞ¸ÄÏ»·¾³±äÁ¿:
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Environment]
"Path"="C:\Oracle\ora90\BIN\"


Ïà¹ØÎĵµ£º

ORACLEµÄË÷ÒýºÍÔ¼ÊøÏê½â

 * Èç¹ûij¸öÔ¼ÊøÖ»×÷ÓÃÓÚµ¥¶ÀµÄ×ֶΣ¬¼´¿ÉÒÔÔÚ×ֶ춶¨ÒåÔ¼Êø£¬Ò²¿ÉÒÔÔÚ±í¼¶¶¨ÒåÔ¼Êø£¬µ«Èç¹ûij¸öÔ¼Êø×÷ÓÃÓÚ¶à¸ö×ֶΣ¬ 
±ØÐëÔÚ±í¼¶¶¨ÒåÔ¼Êø 
* ÔÚ¶¨ÒåÔ¼Êøʱ¿ÉÒÔͨ¹ýCONSTRAINT¹Ø¼ü×ÖΪԼÊøÃüÃû£¬Èç¹ûûÓÐÖ¸¶¨£¬ORACLE½«×Ô¶¯ÎªÔ¼Êø½¨Á¢Ä¬ÈϵÄÃû³Æ 
¶¨Òåprimary keyÔ¼Êø(µ¥¸ö×ֶΣ© 
create t ......

oracle¸ß¼¶sqlµÄ²Î¿¼×ÊÁÏ

 1.¼¯ºÏ²Ù×÷
ѧϰoracleÖм¯ºÏ²Ù×÷µÄÓйØÓï¾ä£¬ÕÆÎÕunion,union all,minus,interestµÄʹÓÃ,Äܹ»ÃèÊö½áºÏÔËË㣬²¢ÇÒÄܹ»½«¶à¸ö²éѯ×éºÏµ½Ò»¸ö²éѯÖÐÈ¥£¬Äܹ»¿ØÖÆÐзµ»ØµÄ˳Ðò¡£
°üº¬¼¯ºÏÔËËãµÄ²éѯ³ÆΪ¸´ºÏ²éѯ¡£¼û±í¸ñ1-1
±í1-1
Operator         Returns       ......

oracleµÄrank,over partitionº­ÊýʹÓÃ

 ¹Ø¼ü×Ö: º­Êýrank, over partitionʹÓÃ
ÅÅÁУ¨rank()£©º¯Êý¡£ÕâЩÅÅÁк¯ÊýÌṩÁ˶¨ÒåÒ»¸ö¼¯ºÏ£¨Ê¹Óà PARTITION ×Ӿ䣩£¬È»ºó¸ù¾ÝijÖÖÅÅÐò·½Ê½¶ÔÕâ¸ö¼¯ºÏÄÚµÄÔªËؽøÐÐÅÅÁеÄÄÜÁ¦£¬ÏÂÃæÒÔscottÓû§µÄemp±íΪÀýÀ´ËµÃ÷rank over partitionÈçºÎʹÓÃ
1£©²éѯԱ¹¤Ð½Ë®²¢Á¬ÐøÇóºÍ
select deptno,ename,sal,
sum(sal)over ......

Oracle sqlplus copyÃüÁîÓ÷¨

±¾ÎĽéÉÜÁËÈçºÎÀûÓÃsqlplus copy ÃüÁîÔÚÁ½¸öÊý¾Ý¿â¼äתÒÆÊý¾Ý
ÎÞÐèÓõ½dblink, Á½¸öÊý¾Ý¿â¼ä²»ÐèÖ±½ÓͨѶ£¬µ±È»£¬ÐèÒªÓÐÒ»¸öclient¶ÎÄÜͬʱÒÔsqlplusÁ¬½Óµ½Á½¸öÊý¾Ý¿â
ÎÊÌâµÄÌá³ö
ÂÛ̳ÉÏÓÐÈËÌá³öÕâÑùµÄÎÊÌ⣺
¼ÙÉèÓÐÁ½¸öÊý¾Ý¿â,·Ö±ð´¦ÓÚÁ½¸ö²»Í¬µÄÍøµ«ÓÐÒ»¸ö¿Í»§»ú°²ÁËÁ½¿éÍø¿¨¿ÉÒÔͬʱÁ¬µ½Á½¸öÊý¾Ý¿âÇëÎÊÈç¹û²»Í¨¹ýÔÚ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ