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

.netµ÷ÓÃoracle³öÏÖÎÞ·¨¼ÓÔØoramts.dll

.netµ÷ÓÃoracle³öÏÖÎÞ·¨¼ÓÔØoramts.dll
     ÔÚµ÷ÓÃoracleʱ³öÏÖÎÞ·¨¼ÓÔØoramts.dll Õâʱ¿ÉÒÔ³¢ÊÔÒÔÏ·½·¨£º
ÏÈÒª¿´ÔÚÁ¬½Ó×Ö·û´®ÖÐ.ÊÇ·ñÌí¼ÓÁËenlist=false;ͨ³£²»Ìí¼ÓÕâ¸öÊôÐÔ..ϵͳ½«²»»áÈ¥×Ô¶¯µ÷ÓÃoramts.dll
ÏêÇéÇë¿´
   ½«msvcrtd.dll¿½µ½ C:windows\system32\


Ïà¹ØÎĵµ£º

Oracleºº×ÖÅÅÐò


ʹÓÃÒ»ÏÂSQL
select * 
from T_0303003 
order by stock_holder
½øÐÐÑ¡È¡Êý¾Ýʱ£¨stock_holderΪ´æ·ÅÖÐÎĵÄ×ֶΣ©£¬½á¹û·¢ÏÖÁ½¿â·µ»ØµÄ¼Ç¼˳Ðò²»Ò»Ö¡£×ÁÄ¥Ö®ºóÓ¦¸ÃΪ×Ö·û¼¯ÎÊÌ⣬һ¸ö¿â×Ö·û¼¯ÎªÏµÍ³Ä¬ÈÏ×Ö·û¼¯£¬ÁíÒ»¸ö¿âΪUTF-8×Ö·û¼¯¡£²éÕÒ×ÊÁϺó·¢ÏÖ£¬¶ÔÓÚÖÐÎÄ×ֶεÄÅÅÐò£¬Ó¦¸ÃÊ¹Ó ......

ORACLE¸´Ï°(Ò»)

ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢     ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1)        VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹Ó ......

Oracleɾ³ý±íÖÐÖظ´¼Ç¼

--刪³ýÖØ復ÁÐ  
  a.Èç¹ûÓÐID×ֶΣ¬¾ÍÊǾßÓÐΨһÐÔµÄ×ֶΠ 
   
  delect   table   where   id   not   in   (  
   
  select   max(id)   from   table   group   by   col1,col ......

Oracle11gR2 for Linux ¾²Ä¬°²×°±Ê¼Ç


±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷;  ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ