¹ØÓÚÓÃdelphiÖÐadoÁ¬½ÓoracleµÄÎÊÌâ - Oracle / ¿ª·¢
ÈçÌâ¡£
ÓÃadoconnectionÁ¬½Óoracle,²âÊÔÁ¬½Ó³É¹¦
ÓÃÒ»adotable¿Ø¼þ£¬ÉèÖÃÆäconnectionΪ¸Õ¸ÕÁ¬½Ó³É¹¦µÄadoconnection
µ«ÊÇÑ¡ÔñtablenameÊôÐÔµÄʱºòÌáʾ£¬Êý¾ÝÌṩÕß»òÆäËü·þÎñ·µ»Øe_fail״̬
лл
ÕâÊÇʲôÎÊÌ⣬ÕÒÁ˺þÃû·¢ÏÖ³öʲôÎÊÌâ¡£¡£ÎÒ°ÑadoconnectionÀïÃæµÄCursorLocation»»³ÉclUseServer¾Í¿ÉÒÔÔÚadotableÀïÃæ·ÃÎʵ½±í£¬µ«ÊÇûÓÐÎÒÔÚoracleÖн¨Á¢µÄ±í¡£ÁíÍâÕâ¸öclUseServerºÍclUseClientÓÐʲô²»Í¬¡£¡£
¸ßÊÖÇë°ïÏÂæ½â¾öÏ£¬¸ãÁËÁ½ÌìÁË£¬»¹Ã»ÓÃadoÁ¬½Óµ½oracle{{
Ïà¹ØÎÊ´ð£º
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó
SQL code:
wi ......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......
ÏÖÓÐparadoxÊý¾Ý¿âʹÓÃBDEÇý¶¯£¬Äâ¸ÄΪC/S°æ£¬Ôö¼ÓÍøÂç¶ÁÈ¡Êý¾Ý¹¦ÄÜ¡£ÇëÄÄλ´óÏÀ£¬ÌṩԴÂë¡£
˵¾ä²»¿ÍÆøµÄ»°£¬ÓÃparadox×öC/SÊÇ×ÔѰËÀ·¡£
»»Ò»¸öÍøÂçÊý¾Ý¿â
ÒòΪ²»Ï붯´óÊÖÊõ£¬½öÄܹ²Ïí¼¸¸öÎļþ¼´¿É¡£
Da ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......