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Êý¾Ý¿â¡£
Ïà¹ØÎĵµ£º
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......
INSTR·½·¨µÄ¸ñʽΪ
INSTR(Ô´×Ö·û´®, Ä¿±ê×Ö·û´®, ÆðʼλÖÃ, Æ¥ÅäÐòºÅ)
ÀýÈ磺INSTR('CORPORATE FLOOR','OR', 3, 2)ÖУ¬Ô´×Ö·û´®Îª'CORPORATE FLOOR', Ä¿±ê×Ö·û´®Îª'OR'£¬ÆðʼλÖÃΪ3£¬È¡µÚ2¸öÆ¥ÅäÏîµÄλÖá£
ĬÈϲéÕÒ˳ÐòΪ´Ó×óµ½ÓÒ¡£µ±ÆðʼλÖÃΪ¸ºÊýµÄʱºò£¬´ÓÓұ߿ªÊ¼²éÕÒ¡£
ËùÒÔSELECT INSTR('CORPORATE FLOOR' ......
1¡¢²éѯµÚ¼¸ÐеļǼ
select sal from emp where rownum=1; //²éѯµÃµ½µÚÒ»ÐмǼ
select sal from emp where rownum=5; //²»¿ÉÒÔ²éѯµ½µÚÎåÐмǼ£¬ÒòΪrownum ×ÜÊÇ´Ó1¿ªÊ¼²éѯµÄ£¬¹ÊÕâÖÖ·½Ê½²»¿ÉÒÔÖ±½ÓµÃµ½µÚ¼¸ÐеļǼ¡£ÈôÏëµÃµ½µÚÎåÐмǼ£¬Ó¦²ÉÓÃÈçÏ·½Ê½£º
select r,sal from (select rownum r,sal from emp) wher ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr6 ......