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ÌõÊý¾Ý¶¼»áÖØ¸´
Ïà¹ØÎÊ´ð£º
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
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 ......