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

OracleÊý¾Ý¿â¶Ë¿ÚÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

¸÷λÅóÓÑ£º
OracleÊý¾Ý¿âĬÈϵÄÁ´½Ó¶Ë¿ÚÊÇ1521£¬Èç¹ûÒªÐ޸쬏ÃÔõôÐ޸ģ¿
±»Ð޸ĺó£¬ÈçºÎ²é¿´Êý¾Ý¿âµ±Ç°Á´½ÓµÄÊÇÄĸö¶Ë¿ÚÄØ£¿
ÐÞ¸ÄÕìÌýÎļþlistener.ora,ÕÒµ½ÎļþÄÚÈÝPORT = 1521,°Ñ1521Ð޸ijÉÄãÐèÒªµÄ¶Ë¿Ú,ÖØÐÂÆô¶¯ÕìÌý·þÎñ.

лл£¬ÎÒÊÇÐÂÊÖ£¬ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ£¿ÈçºÎÆô¶¯ÕìÌý·þÎñ£¿

°²×°ºó£¬ÅäÖù¤¾ß NET MANAGEÐÞ¸Ä

ÒýÓÃ
лл£¬ÎÒÊÇÐÂÊÖ£¬ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ£¿ÈçºÎÆô¶¯ÕìÌý·þÎñ£¿


1.ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ: $ORACLE_HOME/network/admin Ŀ¼Ï£¡
2.ÈçºÎÆô¶¯ÕìÌý·þÎñ£º cmd--> lsnrctl start


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ