ORACLE @µÄ×÷ÓÃ
ÇëÎÊÓÐ ±íÃû@Êý¾Ý¿âÃûÕâÑùµÄд·¨Â𣿠delete from ±íÃû@Êý¾Ý¿âÃû
SQL code: ûÓÐ,Ö»ÓÐд³É delete from Êý¾Ý¿âÃû@±íÃû ˵´íÁË,Èç¶þ¥˵Õý½â! delete from Óû§.±íÃû SQL code: delete from ±íÃû@Êý¾Ý¿âÃû ÕâÑùµÄ·½Ê½Ó¦¸ÃÊÇÓõÄdatabase link¡£ ±íÃû@Êý¾Ý¿â±ðÃû Ï൱ÓÚÔ˳ÌÊý¾Ý¿âµÄ±ðÃû¡£ Ô¶³Ì¡£ ÇëÎÊdblinkÓ¦¸ÃÔõô´´½¨£¬ÄܸøÎÒ¸ö¾ßÌåµÄÀý×ÓÂð ÒýÓà DBLINK ʱ¿ÉÒÔ delete from ±íÃû@DBLink_name Oracle DB Link http://blog.csdn.net/tianlesoftware/archive/2009/10/19/4698642.aspx ÒѾOKÁË
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ 2009-9-29 12:12:12 µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿ ¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼ Ö麣ÄDZßËÆºõûÉîÛÚºÃ. Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
ÎÒÏÖÔÚÐèÒªËæ»ú³éÈ¡table±íµÄµÄÊý¾Ý£¬±íµÄÊý¾ÝÓÐ100Íò£¬table´æÔÚÒ»¸ö×Ö¶Îa ÒªÇó³éÈ¡³öÀ´µÄÊý¾Ýa×ֶεÄ×ܺÍÒªµÈÓÚ1000£¬ËÓкõķ½·¨£¬Çë½ÌÁË£¡ 1Â¥ÒýÓõÄÎÄÕ£¬»á·ñÖØ¸´È¡ÏàͬµÄ¼Ç¼ºÅ£¿ ÀýÈ磺 id ......