oracleʱ¼ä´ÁÈçºÎʹÓà - Oracle / ¸ß¼¶¼¼Êõ
ÎÒÏëÔÚÒ»¸ö±íÀïÔö¼ÓÒ»¸öʱ¼ä´Á£¬È»ºóÊý¾ÝÓб仯µÄʱºòÏàÓ¦µÄʱ¼ä´ÁÒ²¸Ä±ä¡£ 1 ²»ÖªµÀÈçºÎ»ñµÃÄÇô¸ß¾«¶ÈµÄʱ¼ä 2 ʱ¼ä´ÁÊÇ·ñ»áÖØ¸´ 3 ʱ¼ä´Á»¹ÓÐʲô±ðµÄÓ÷¨Â𣿠ÓеãÃÔ㣬Çë´ó¼ÒÏê½â£¡
SYSDATE ?? select systimestamp from dual; ʱ¼ä´Á²»»áÖØ¸´ÒýÓà select systimestamp from dual; ʱ¼ä´Á²»»áÖØ¸´ Èç¹û²¢·¢·ÃÎÊÁ¿´óµÄ»°£¬»á´æÔÚÖØ¸´µÄ¿ÉÄÜÂð£¿ÒýÓà ÒýÓà 2 Â¥ ngx20080110 µÄ»Ø¸´: select systimestamp from dual; ʱ¼ä´Á²»»áÖØ¸´ Èç¹û²¢·¢·ÃÎÊÁ¿´óµÄ»°£¬»á´æÔÚÖØ¸´µÄ¿ÉÄÜÂ𣿠²»»áÓÐÎÊÌâ¡£ËüµÄ¾«¶ÈºÜ´ó¡£ systimestamp ¾«È·µ½ºÁÃë ²»»áÓÐÖØ¸´µÄ SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------- 27-5Ô -10 01.25.01.359000 ÏÂÎç +08:00 ÎÒÊÔ¹ýÁË systimestamp ÏÔʾµÄ¾«¶ÈΪÃëºó6λ¡£ ´óÊý¾ÝÁ¿²åÈë ÔÚÎÒµÄpcÉÏ Ã¿100-200ÌõÊý¾Ý¶¼»áÖØ¸´
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉ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 ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£ 2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£ 3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££» vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......