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

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í£Ö¹¡±×´Ì¬£¬Æô¶¯²»ÁË£¬Ò²¹Ø±Õ²»ÁË¡£

ÔÚÏߵȸßÊֻشð!ллÏÈ£¡
´íÎóÌáʾÊÇʲô?

ÖØÆôһϻúÆ÷ÊÔÊÔ£¬

Èç¹û»¹ÊÇ·þÎñ²»ÄÜÆô¶¯µÄ»°£¬°ÑÄãµÄalert.logµÄ´íÎó¿¼³öÀ´¿´¿´¡£

ÏñÂ¥ÉÏËù˵µÄ£¬ÖØÆôһϻúÆ÷¡£È»ºóÔÙÆô¶¯Õâ¸ö·þÎñ£¬Èç¹ûÆô¶¯²»ÁË£¬Ó¦¸Ã»á±¨´í¡£°Ñ±¨´íÂëÌù³öÀ´¿´¿´¡£


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

Çë½ÌADO.NET·ÃÎÊOracleµÄ×Ö·û´®µÄ¸ñʽ

ƽʱ¶¼ÊÇÁ¬½ÓMSSQL û̫עÒâÕâ¸öÎÊÌâ..½ñÌìÒòΪÐèÒª.ÔÚÍøÉÏÕÒÁËÒ»ÏÂ..Óкöà.. ¶¼ÊÔÁË.²»ÐÐ
ºÜ¶à¶¼ÊDZ¨:
    δ´¦ÀíµÄÒì³£;System.Exception System.Data.OracleCilent ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1. ......

oracle textÈ«ÎļìË÷(׿±)

oracle text×öË÷Òýͬ²½µÄʱºò,Ó°Ïì²éѯÂð?ÈçºÎÖ¤Ã÷ÄØ?
ͬʱË÷Òýͬʱ²éѯ,²¢·¢½øÐÐͬһÌõ¼Ç¼
×Ô¼º¶¥Ò»¸ö

²Î¿¼£ºhttp://blog.csdn.net/fengzhu1008/archive/2009/01/15/3784853.aspx

text×öË÷Òý¡£ºÜ»áÓ°ÏìË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ