ORACLEÃâ·Ñ¹«¿ª¿Î
²©Ñå¿Æ¼¼Oracle erpÃâ·Ñ½²×ù
×÷ΪOracle¹«Ë¾¹Ù·½ÊÚȨÅàѵ»ú¹¹£¬²©ÑåOracle erpרҵÈÏ֤ר¼Ò¿Î³ÌÔÚ±±¾©¡¢ÉϺ£Í¬²½¿ªÕ¹Oracle erpÅàѵ¿Î³Ì¡£
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñÓ¦ÓÃÈí¼þÄܹ»×Ô¶¯»¯²¢¼ò»¯¿Í»§µÄ²ÆÎñÒµÎñÁ÷³Ì£¬°ïÖúÆóÒµ»ñµÃÆóÒµ·¶Î§ÄÚµÄÈÕ³£ÉÌÎñÖÇÄÜ£¬´Ó¶ø×ö³ö¸üÃ÷Öǵľö²ß¡¢¸Ä½øÔËÓª²¢½ÚÔ¼³É±¾¡£Í³Ò»µÄÊý¾ÝÄ£ÐÍΪËùÓеIJÆÎñÐÅÏ¢ÌṩÁ˵¥Ò»¾«È·µÄÊÓͼ£¬Ò²°üÀ¨360¶ÈµÄ¿Í»§È«¾°¡£OracleÌṩ²ÆÎñÄ£¿éÉî¶ÈÅàѵ£¬°ïÖúÆóÒµÓ¦ÓÃϵͳ»ñµÃÐÐÒµÁìÏȵÄÐÔÄܺͿÉÀ©Õ¹ÐÔ¡£
²©ÑåOracle erp¹ËÎÊѧԺӦ¹ã´óѧԱµÄÇ¿ÁÒÒªÇó£¬ÌØÔÚ±±¾©¼°ÉϺ£¾Ù°ìOracleµç×ÓÉÌÎñÌ×¼þR12²ÆÎñÓ¦ÓõÄÃâ·Ñ½²×ù£¬¾ßÌå¿ÎÄÚÈÝ°²ÅÅÈçÏ£º
No
¿Î³ÌÃû³Æ
¿Î³ÌÃèÊö
ʱ¼ä
1
R12 Oracle µç×ÓÉÌÎñÌ×¼þʵʩ¹æ»®Ö¸ÄÏ
½éÉÜR12Ó¦ÓÃϵͳµÄ»ù±¾²Ù×÷
2010
´ý¶¨
2
R12 Oracle ×ÜÕ˹ÜÀí»ù´¡
½éÉÜR12×ÜÕʱê×¼¹¦ÄܵIJÙ×÷ºÍÉèÖÃ
3
R12 Oracle Ó¦¸¶¹ÜÀí»ù´¡
½éÉÜR12Ó¦¸¶·¢Æ±¡¢Ó¦¸¶¿îÏîºÍÍøÉÏ·ÑÓúËÏúµÈÇ¿´ó¹¦ÄÜ
½²×ùµØÖ·£º´ý¶¨
×Éѯµç»°£º010---82826100--2246 ºÂС½ã
±¨Ãû±íÏÂÔØ£ºhttp://edu.beyondsoft.com/images/upfile/20091020145656481.doc ÌîдºÃ±¨Ãû±í·¢ÖÁ haoguojing@beyondsoft.com
Íø Ö·£ºhttp://edu.beyondsoft.com
QQ£º 297539145
MSN£º haoguojing01@hotmail.com
ÈÏÖ¤½»Á÷Ⱥ£º108882889
Ïà¹ØÎĵµ£º
1¡£web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2. c#´úÂëÖÐ
using System.Data.OracleClient;
public DataTable GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,Date ......
Temporary TablesÁÙʱ±í
1¼ò½é
ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
»òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
µ«ÊÇÁÙʱ± ......
ÔÚÊý¾Ý¿âµÄÈÕ³£Ñ§Ï°ÖУ¬·¢ÏÖ¹«Ë¾Éú²úÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ätempʹÓÃÇé¿ö´ïµ½ÁË30G£¬Ê¹ÓÃÂÊ´ïµ½ÁË100%£»´ýµ÷ÕûΪ32Gºó£¬Ê¹ÓÃÂÊ»¹ÊÇΪ100%£¬µ¼Ö´ÅÅÌ¿Õ¼äʹÓýôÕÅ¡£¸ù¾ÝÁÙʱ±í¿Õ¼äµÄÖ÷ÒªÊǶÔÁÙʱÊý¾Ý½øÐÐÅÅÐòºÍ»º´æÁÙʱÊý¾ÝµÈÌØÐÔ£¬´ýÖØÆôÊý¾Ý¿âºó£¬temp»á×Ô¶¯ÊÍ·Å¡£ÓÚÊÇÏëͨ¹ýÖØÆôÊý¾Ý¿âµÄ·½Ê½À´»º½âÕâÖÖÇé¿ö£¬µ«ÊÇÖØÆôÊý¾Ý ......
ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼--------------------
......
ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼-------------- ......