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

ADO.NETµ÷ÓÃOracle´æ´¢¹ý³Ì?

Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼­.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇû·¨´Ó±íÖлñÈ¡Êý¾Ý.ÅŲéºóÊÇÒòΪÎÞ·¨Íù±íÖвåÊý¾Ý,µ«´æ´¢¹ý³ÌÊǶԵÄ,²»ÂÛÊÇSQL Plus»¹ÊÇÇàÍܶ¼ÐÐ.¾ÍÊDz»ÄÜÓÃADO.NET»ñÈ¡µ½½á¹û.
´æ´¢¹ý³ÌÖÐÓжദCommit,Õâ¸öÓÐÓ°ÏìÂð?֮ǰµÄ´æ´¢¹ý³ÌÖÐûÓз´±íÖвåÊý¾ÝʱÊÇ¿ÉÄÜÖ´ÐеÄ.



ÎҵľÍÊÇÕâÑùµ÷ÓõÄ.
´úÂëûÎÊÌâ.
ÒòΪ֮ǰµÄ´æ´¢¹ý³Ì¶¼ÄÜÖ´ÐÐ.
ÎÊÌâÊÇÏÖÔÚÕâ¸ö´æ´¢¹ý³ÌÖÐÒªÉæ¼°µ½Èý¸ö±í,ÏȽ«Òª´¦ÀíµÄÊý¾Ý²åµ½A±íÖÐ,commit;,È»ºó´ÓÖÐÈ¡³ö²åÈëµÄÊý¾Ý½øÐÐÒ»¶¨µÄÂß¼­´¦Àíºó½«ÁÐÐÅÏ¢²åÈëµ½B±í,commit;,½«Êý¾Ý²åÈëµ½C±í,commit;,·µ»ØΨһ±êʶ·û.
ÔÚ´úÂëÖлñÈ¡±êʶ·û¸ù¾ÝB±íÖеÄÐÅÏ¢Éú³ÉSQLÓï¾ä,´ÓC±íÖÐÈ¡³öÊý¾Ý.
ÏÖÔÚÎÊÌâ¾ÍÊÇA,B,C±í¶¼Ã»ÓÐÊý¾Ý,µ«¿ÉÒÔ·µ»Ø±êʶ·û.

²¹³ä:
ÔÚSQL Plus ¼°ÇàÍÜÖпÉÒÔÕý³£Ö´ÐÐ.


¸Ðл¥ÉϵÄ,µ«ÎÊÌâÔÚÓÚ´æ´¢¹ý³ÌÔÚͨ¹ýADO.NETÖ´ÐÐʱ¾Í²»Íù±íÖвåÊý¾ÝÁË.

oracleÖд洢¹ý³Ì·µ»Ø½á¹û¼¯ÐèÒªÓÃÓα귵»Ø


ÎÊÌâÕÒµ½ÁË.
½«²åÈëÊý¾ÝµÄSql¸Ä³É×Ö·û´®ÐÎʽִÐоͿÉÒÔÁË.
ÕæÆæ¹Ö.

½â¾öÁ˾ͺÃ


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

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

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼È붼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ