OracleÊý¾Ý¿âÁ¬½Ó
³ÌÐòÔËÐÐÔÚûÓа²×°Oracle¿Í»§¶ËµÄ»úÆ÷ÉÏ£¬Á¬½Óµ½Ô¶³Ì·þÎñÆ÷£¬ÔõôÑù²ÅÄÜÁ¬ÉÏÊý¾Ý¿â£¬±¾µØÐèҪʲôÉèÖûòÕß±ØÐ밲װʲôÇý¶¯Ã´£¬×îºÃÄܲ»°²×°Èκζ«Î÷¡£
Thanks in advance.
µÃ×°¿Í»§¶Ë.ûÇý¶¯Á¬²»ÉϵÄ.
×°Oracle ODBC Çý¶¯
×°ÉÏÇý¶¯
±ØÐë×°,²»×°µÄ»°.¿ÉÒÔ¿¼ÂÇÓÃweb servicesµÈÊÖ¶ÎÈÆһϠ(c/s)
×°ÉÏ ¿Í»§¶Ë¾ÍÐÐÁË
¶÷¡£Ð»Ð»Â¥Éϼ¸Î»¡£Ä¿Ç°µÄÈ·ÊÇÓÃwebservices¸ãµÄ¡£Ö®Ç°ÓôÃÆ»µÁË
Ïà¹ØÎÊ´ð£º
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......