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ÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......