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

¹ØÓÚÓÃdelphiÖÐadoÁ¬½ÓoracleµÄÎÊÌâ - Oracle / ¿ª·¢

ÈçÌâ¡£
ÓÃadoconnectionÁ¬½Óoracle,²âÊÔÁ¬½Ó³É¹¦  
  ÓÃÒ»adotable¿Ø¼þ£¬ÉèÖÃÆäconnectionΪ¸Õ¸ÕÁ¬½Ó³É¹¦µÄadoconnection  
  µ«ÊÇÑ¡ÔñtablenameÊôÐÔµÄʱºòÌáʾ£¬Êý¾ÝÌṩÕß»òÆäËü·þÎñ·µ»Øe_fail״̬  
  лл 


ÕâÊÇʲôÎÊÌ⣬ÕÒÁ˺þÃû·¢ÏÖ³öʲôÎÊÌâ¡£¡£ÎÒ°ÑadoconnectionÀïÃæµÄCursorLocation»»³ÉclUseServer¾Í¿ÉÒÔÔÚadotableÀïÃæ·ÃÎʵ½±í£¬µ«ÊÇûÓÐÎÒÔÚoracleÖн¨Á¢µÄ±í¡£ÁíÍâÕâ¸öclUseServerºÍclUseClientÓÐʲô²»Í¬¡£¡£


¸ßÊÖÇë°ïÏÂæ½â¾öÏ£¬¸ãÁËÁ½ÌìÁË£¬»¹Ã»ÓÃadoÁ¬½Óµ½oracle{{


Ïà¹ØÎÊ´ð£º

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

OracleÐÐתÁÐ - Oracle / ¸ß¼¶¼¼Êõ

select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ
1,2,3,4
ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û
1
2
3
4
ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö???
ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó

SQL code:
wi ......

ÓÃibatisµ÷ÓÃoracleº¯ÊýµÄÎÊÌâ - Java / Web ¿ª·¢

oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
  p_mobileNumber in VARCHAR2,
  p_cityid out NUMBER
) Return NUMBER
IS
  p_areacode varc ......

¿ÄÇóC/SÔ´Âë - Delphi / Êý¾Ý¿âÏà¹Ø

ÏÖÓÐparadoxÊý¾Ý¿âʹÓÃBDEÇý¶¯£¬Äâ¸ÄΪC/S°æ£¬Ôö¼ÓÍøÂç¶ÁÈ¡Êý¾Ý¹¦ÄÜ¡£ÇëÄÄλ´óÏÀ£¬ÌṩԴÂë¡£
˵¾ä²»¿ÍÆøµÄ»°£¬ÓÃparadox×öC/SÊÇ×ÔѰËÀ·¡£
»»Ò»¸öÍøÂçÊý¾Ý¿â

ÒòΪ²»Ï붯´óÊÖÊõ£¬½öÄܹ²Ïí¼¸¸öÎļþ¼´¿É¡£

Da ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ