oracleÊý¾Ý¿âµ¼Èëµ½sql server2005
ÒýÓÃ:http://blog.csdn.net/wizardlun/archive/2009/09/08/4531576.aspx
½ñÌ죬ÖÕÓÚ°ÑoracleÖеÄÊý¾Ý¿âµ¼Èëµ½sql serverÖÐÁË£¬·½·¨ÈçÏ£º
Ò»¡¢ÔÚsql serverÖн¨¸öͬÃûÊý¾Ý¿â£¬ÀýÈçssdb¡£
¶þ¡¢ÓÒ¼üµã»÷ssdb,Ñ¡Ôñ“ËùÓÐÈÎÎñ”——>“µ¼ÈëÊý¾Ý”£¬¾Í»áµ¯³öÒ»¸ö“DTSµ¼Èë\µ¼³öÏòµ¼”£¬
µã»÷ÏÂÒ»²½¡£
¶þ¡¢ÈçÏÂͼ£º
ÔÚ“Êý¾ÝÔ´”ÏÂÀÁбí¿òÖÐÑ¡Ôñ£º“Microsoft OLE DB Provider Oracle”,ÈçÉÏͼ£¬µã»÷“ÊôÐÔ”°´Å¥£¬µ¯³öÈçÏÂͼ£º
ÔÚ“ÊäÈë·þÎñÆ÷Ãû³Æ”Îı¾¿òÀïÊäÈë“SID_Ö÷»úÃû”£¬SID,Ä㽨µÄÊý¾Ý¿âµÄsid,Ö÷»úÃû£¬ÒªÁ¬½ÓµÄoracle·þÎñÆ÷¡£
ÔÙÊäÈëµÇ½Êý¾Ý¿âµÄÓû§Ãû³ÆºÍÃÜÂ룬µã»÷“²âÊÔÁ¬½Ó”£¬µ¯³ö“²âÊÔÁ¬½Ó³É¹¦”£¬ÈçÏÂͼ£º
Èý¡¢µã»÷È·¶¨£¬µã»÷ÏÂÒ»²½£¬½øÈë“Ñ¡ÔñÄ¿µÄ”´°¿Ú£¬ÈçÏÂͼ
"Ä¿µÄ",ĬÈϾͿɡ£“·þÎñÆ÷”£¬¸ù¾Ý×Ô¼ºÐèÒª£¬Ñ¡Ôñ¡£¸ù¾Ý×Ô¼ºÉèÖõÄÇé¿öÑ¡Ôñ“ʹÓÃWindowsÉí·ÝÑéÖ¤”»¹ÊǓʹÓÃSql ServerÉí·ÝÑéÖ¤”¡£Ìرð×¢ÒâµÄÊÇ£¬“Êý¾Ý¿â”ҪѡÔñÒªµ¼ÈëÊý¾ÝµÄÊý¾Ý¿â¡£µã»÷ÏÂÒ»²½¡£
ËÄ¡¢½øÈë“Ö¸¶¨±í¸´ÖÆ»ò²éѯ”´°¿Ú£¬ÈçÏÂͼ£º
ĬÈÏ£¬µã»÷ÏÂÒ»²½¡£
Îå¡¢½øÈë“Ñ¡ÔñÔ´±íºÍÊÓͼ”´°¿Ú£¬ÈçÏÂͼ£º
Ñ¡ÔñÄãÒªµ¼ÈëµÄ±í£¬“ת»»”Ò»À¸Óиö“ ”°´Å¥£¬µã»÷£¬½øÈë“ÁÐÓ³ÉäºÍת»»”´°¿Ú£¬ÈçÏÂͼ£º
¸ù¾Ý×Ô¼ºÐèÒªÉ趨¡£ÉèÖÃÍêºó£¬µã»÷ÏÂÒ»²½¡£
Áù¡¢½øÈ등£´æ¡¢µ÷¶ÈºÍ¸´Öưü”´°¿Ú£¬ÈçÏÂͼ£º
¸ù¾Ý×Ô¼ºµÄÐèÒª£¬ÉèÖ㬵ã»÷ÏÂÒ»²½¡£
Æß¡¢½øÈë“ÕýÔÚÍê³ÉDTSµ¼Èë\µ¼³öÏòµ¼”´°¿Ú£¬µã»÷“Íê³É”°´Å¥¡£
ÕâÑù£¬¾Í°ÑoacleÊý¾Ý¿âµ¼Èëµ½ÁËsql serverÊý¾Ý¿â¡£
Ïà¹ØÎĵµ£º
ǰ¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕŰ×Ö½ÉÏ»³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷֨װÁ˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹û֨װµÄoracleºÍÒÔǰË𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔÊý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
  ......
Ò»¸ö¼òµ¥µÄoracle·ÖÒ³´æ´¢¹ý³ÌµÄʵÏֺ͵÷Óá£ÔÚ¿´ÁËÖÚ¶àµÄ·ÖÒ³´æ´¢¹ý³ÌÒÔºó·¢ÏÖ¶¼ÊÇÕë¶ÔsqlserverµÄ£¬¶øÃ»ÓÐoracleµÄ£¬Òò´ËÏëдһ¸ö¹ØÓÚoracleµÄ´æ´¢¹ý³Ì£¬ÒòΪÎÒÓõ½µÄÊý¾Ý¿âÊÇoracle¡£
Oracle·ÖÒ³´æ´¢¹ý³ÌµÄ˼·ÓÚsqlserverµÄ˼·ÊÇÒ»ÑùµÄ£¬µ«ÊÇÎÒÕâÀï×öÁ˵ã¸Ä¶¯£¬ÔÚÒòΪOracleµÄÓï·¨ºÍ¹æÔòµÄ²»Í¬ËùÒÔ£¬Oracle·ÖÒ³´æ´¢ ......
ʹÓÃCursor:
--²âÊÔһϣ¬½ñÌì²ÅÉêÇëʹÓÃitpub.net µÄblog
declare
RoomID Room.RoomID%Type;
RoomName Room.RoomName%Type;
cursor crRoom is
select RoomID,RoomName
from Room;
begin
open crRoom;loop;
fetch crRoom into RoomID,RoomName;
exit when crRoom%notFound;
end loop;
close crRoom;
end;
& ......