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

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ÁË


Ïà¹ØÎÊ´ð£º

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

ÇóʹÓÃ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Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......

ORACLEËæ»ú¼Ç¼³éÈ¡

ÎÒÏÖÔÚÐèÒªËæ»ú³éÈ¡table±íµÄµÄÊý¾Ý£¬±íµÄÊý¾ÝÓÐ100Íò£¬table´æÔÚÒ»¸ö×Ö¶Îa
ÒªÇó³éÈ¡³öÀ´µÄÊý¾Ýa×ֶεÄ×ܺÍÒªµÈÓÚ1000£¬Ë­Óкõķ½·¨£¬Çë½ÌÁË£¡


1Â¥ÒýÓõÄÎÄÕ£¬»á·ñÖØ¸´È¡ÏàͬµÄ¼Ç¼ºÅ£¿
ÀýÈ磺
id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ