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

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ÌõÊý¾Ý¶¼»áÖØ¸´


Ïà¹ØÎÊ´ð£º

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

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 / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......

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

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

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ºÅ