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 for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
OracleÖÐÓû§ÃûÊÇʲô£¿ ÃèÊöÇå³þÒ»µã£¡ ORACLEÊý¾Ý¿âÖÐÓкܶàÄÚÖõÄÓû§Ãû£¬sys¾Í²»ËµÁË£¬»¹ÓÐscottÃÜÂëÊÇtiger.³ýÁËsys,ÆäËûÓû§¶¼ÊÇËù¶¨µÄ£¬½â³ýËø¶¨ºó²ÅÄÜʹÓá£ÔÚ±¾»úµÇ½Êý¾Ý¿âʱ£¬sysµÄÃÜÂë¿ÉÒÔËæÒâÊäÈë¡£
......