myeclipseÁ¬½ÓOracle±¨´í - Oracle / ¿ª·¢
ÎÒÓÃmyeclipseÁ¬½ÓOracleÒ»Ö±±¨´í£¬Ò»ÏÂÊDZ¨´í½ØÍ¼£¬
Çó¸ßÈËÏàÖú¡£
ÎÞͼÎÞÕæÏà....
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png
....
Äã¿´¿´Çý¶¯ºÍORACLEµÄ°æ±¾¶ÔӦô....
HTML code:
file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/SF/Oracle%20JDBCÁ¬½Ó´íÎó.png
ÄãÕâͼƬ¿´²»µ½£¬¹À¼ÆÒ»°ãÎÊÌâ¾ÍÊÇ oracle°æ±¾µÄÊÂÇé¡£lib°ü¿´¿´¡£
圖Ƭ¿´²»ÁË£¬說詳細點°É
¿´²»¼ûͼƬ¡£
http://blog.csdn.net/huangyunzeng2008/archive/2009/12/18/5035055.aspx
½èÓÃEclipseµÄ DB Browser°É,Äǹ¤¾ßÁ´Êý¾Ý¿âºÜ·½±ãµÄ,»áÓÐÏòµ¼Ö¸ÒýÄãÔõÑù²Ù×÷.
7Â¥ÎĵµºÜºÃ °¡
Ò»¸öÊÇȱÉÙ°ü°É
{{
Ïà¹ØÎÊ´ð£º
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......
½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:
update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
ÏÖÔÚ ÎÒÓÐ Êý¾Ý¿â oracle_A £¬ÀïÃæÓÐÕűí Ϊ table_A, È»ºóÎÒÒª¶¨Ê±µÄ °Ñ ÁíÒ»¸öÊý¾Ý¿â oracle_B,ÀïÃæµÄÒ»Õűí table_BµÄÊý¾Ý£¬ÐÂÔö·ÅÈëtable_AÀȻºóÔÙÇå¿Õtable_B£¬ÇëÎÊÓ¦¸ÃÔõô×ö£¿
ÓÃд¸ö´æ´¢¹ý³Ì£¬È»ºóÓ ......