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

Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡

ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡

ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100

ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬

ÎÒÔÚ±¾»ú×°Á˸öoracle XE Client£¬ÇëÎʸÃÈçºÎÁ¬½Ó ÐéÄâ»úÉϵÄoracle

ÎÒÓà DRIVER={Microsoft ODBC for Oracle};UID=¡°system¡°;PWD=¡±5897577¡°;SERVER=¡±Êý¾Ý¿âÃû×Ö ;¡±

°ÑÎÒдµÄ³ÌÐò·Åµ½ÐéÄâ»úÉÏ¿ÉÒÔÁ¬½Ó£¬·Åµ½±¾»úÕâÑù¾Í²»ÄÜÁ¬½ÓÁË£¡

ÇëÎÊÈçºÎÐ޸쬻òÕ߯äËû·½·¨£¡

ÄÇÎÒÈí¼þÖÐÔõÃ´Ð´ÄØ£¿

ÂÛ̳ÈËÆøÔõôÕâôÉÙ


Ïà¹ØÎÊ´ð£º

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

Çë½Ì£ºÈçºÎ½«sqlserverºÍoracleÖеÄÊý¾ÝÏ໥¸´ÖÆ

ÄÜ·ñÓÃÓï¾äʵÏÖ¡£¶ø²»ÊÇÏֳɵŤ¾ß£¿

Â¥ÉϵÄÐֵܿÉÒÔÏêϸһЩÂð£¿
×£Äã½ÚÈÕ¿ìÀÖ£¡¹þ¹þ

½ÚÈÕ¿ìÀÖ

SQL code:

Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
......

oracleÓësqlserverµÄ²ÎÊý¸ñʽ²»Ò»Ö£¬Âé·³

Èç¹ûÒ»¸ö³ÌÐòÏëÖ§³ÖsqlserverÓëoracleÊý¾Ý¿âµÄ»°¡£³ýÁËdbhelperÀàÐèÒª¸Ä±äÖ®Í⣬²ÎÊý´«µÝÒ²ÊǸöÎÊÌâ¡£

sqlserverµÄ²ÎÊýǰ׺ÊÇ ¡°@¡±£¬¶øoracleÊÇ ¡°:¡±

ÇëÎÊÓÐûÓÐʲôͨÓýâ¾ö·½·¨£¿ÎÒ²»ÏëÒ»¸öselect ......

oracle´æÈ¡Ð¡ÓÚ1µÄСÊý£¬ÎªÊ²Ã´ÊÇûÓÐÁã

ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É  .5  µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾ­ÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿

ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ