oracleµÄ¼àÌý³ÌÐòÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÕâÀïÊÇÈý¸öÈËÓ÷ÓÉÉϵÄ
ÒÔǰµÄIPµØÖ·ÊÇ192.168.1.100
ºóÀ´µØÖ·²»ÖªµÀÔõôµÄ¾Í±ä³É101ÁË
ÏÖÔÚ¼àÌý³ÌÐòÆô¶¯Ê§°ÜÁË£¬±¨1067´íÎó
ÎÒÔÚtnsnames.oraÀïÃæ°Ñhost¸Ä³ÉÁËÏÖÔÚµÄIPµØÖ·»¹ÊDz»ÐÐ
Ôõô½â¾ö£¿
»¹ÓÐÄܲ»Äܲ»ÓÃIPѽ£¬²»È»Ã¿´ÎIP±äÁ˶¼³öÏÖÕâÖÖÇé¿ö
ÄѵÀ²»ÄÜÓÃlocalhostÂð£¿
ÄÜÓÃlocalhost£¬µ«ÊÇÒ»°ã²»Óã¡
»»³ÉhostnameÒ²²»ÐÐÂð£¿
ÔÚlistener.oraϰѵØÖ·¸ÄÁ˾ÍÐÐÁË
ÔÚlistener.oraϰѵØÖ·¸ÄÏÂ
Ïà¹ØÎÊ´ð£º
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
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 ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......