û¸É¹ýÕâÊ£¬Ò²²»ÖªµÀoracleÊý¾Ý¿âɶÑù£¬Çë½Ì´óϺÃǾßÌå²½ÖèÊÇʲô£¿ÐèҪעÒâЩʲô£¿
ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥?
Õæ¸öÊý¾Ý¿â
Õû¸öÊý¾Ý¿â£¬ÁíÍâÎÒÊÇ´Óһ̨װÓÐoracleµÄµçÄÔµ¼Èëµ½Áíһ̨װÓÐsql serverµÄµçÄÔÖС£¶àл£¡
ÒýÓà ÊÇÕû¸ö¿âµÄÊý¾Ý»¹ÊÇ±íµ¥? ¸ÕgoogleÁËÏ£¬Ò²Ã»ÕÒµ½oracle µ¼ÈëSQL serverµÄ·½·¨,Ö»ÕÒµ½Á˸öSQL server ºÍ oraclµÄÁ¬½Ó£¬ Èç¹û¿ÉÒÔ£¬Á¬½ÓÉÏÁ˾ͿÉÒÔʹÓÃÁË£¬¾Í²»Óõ¼ÈëÁ˰É.
Â¥Ö÷¿ÉÒÔÊÔÊÔ..
ÒÔSQL Server 2000ΪÀý˵Ã÷SQL Serverµ½OracleÁ¬½Ó·þÎñÆ÷µÄ¾ßÌåʵÏÖ¹ý³Ì¡£
1.ÒªÇópc»úÉϰ²×°oralce¿Í»§¶ËÈí¼þºÍsqlserver2000Èí¼þ¡£
2.¿Í»§¶ËµÄÅäÖÃtnsnames.oraÎļþ£¬ÅäÖÃËùÒªÁ¬½ÓµÄÊý¾Ý¿â·þÎñÆ÷£¨windows£¬unixµÈƽ̨¾ù¿ÉÒÔ£©
eg£ºtnsnames.ora
......
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.11.90)(PORT = 1521))
)
(CONNECT_DATA =
(sid = blue)
(SERVER = DEDICATED)
)
)
......
3.ÅäÖÃwindowsµÄODBCÊý¾ÝÔ´£º
¿ªÊ¼²Ëµ¥—¡·ÉèÖס·¹ÜÀí¹¤¾ß—¡·Êý¾ÝÔ´£¨ODBC£©—¡·½øÈëÅäÖÃÓû§DSN»òÕßϵͳDSN¾ù¿ÉÒÔ£ºÌí¼Ó—¡·Ñ¡ÔñMicrosoft ODBC for oracle—¡·×Ô¶¨ÒåÊý¾ÝÔ´Ãû³Æ£¨×îºÃ¸útnsÖÐÁ¬½Ó´®Í¬Ãû£¡£©—¡··þÎñÆ÷Ãû³Æ£¨±ØÌÌîдtnsÎļþÖеÄÁ¬½Ó´®Ãû³Æ£©—¡·Íê³É¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÕâÑùдµÄ select top 5 * from city where id not in(select top (5*"&page-1&") id from city) .. ºÜʧ°ÜµÄ »¹ÒªÏÈÅжÏÊDz»ÊǵÚÒ»Ò³ È»ºóÑ¡ÔñÐÔÖ´ÐÐ sql .. д×Åд×ÅÎÒ ......
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
¿´µ½ÍøÉÏÓкܶàÏàͬµÄ´ð°¸£¬µ«ÊÇÔÚÎÒʹÓÃvmϲ¢Ã»Óз¢ÏÖÕâЩĿ¼¡£ ²Ù×÷ϵͳ£ºcentos4.5 ÐéÄâ»úÉϰ²×°£¬Ö®Ç°°²×°ÁËoracle10g£¬½ñÌìÐèÒªÍêÈ«Ð¶ÔØ£¬ÌýºÜ¶àÈË˵ֱ½Óɾ³ýÎļþĿ¼¼´¿É£¬Çë¸÷λ°ïæÊDz»ÊÇÕâÑù£¬ ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
import java.sql.*; public class Test { public static void main(String[] srg) { String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //¼ÓÔØJDBC ......