Oracle °æ±¾ÎÊÌâ
ÎÒÃǶ¼ÖªµÀ£¬OracleÖеÄtimestampºÍdateÒ»Ñù£¬µ«ËüÊÇ´ÓdateÀàÐÍÀ©Õ¹³öÀ´µÄ£¬ÏÖÔÚÎÒÒªÖªµÀµÄÊÇ£º
OracleÊÇ´ÓÄĸö°æ±¾¿ªÊ¼ÍƳöµÄtimestampÀàÐÍ£¿ÊÇ8i¡¢9i»¹ÊÇ10g£¿
ÎÒÒªÃ÷È·µÄ´ð°¸¡£ÄÄλCSDNµÄÅóÓÑÖªµÀÈ·ÇеĴð°¸Çë¸æËßÎÒ£¬ÎÒÁ¢¿Ì½áÌù¡£
ÓÉÓÚÎÒûÓÐ×ÊÁϲ鿴£¬ÍøÉÏҲû²éµ½£¬ÏÖÔÚÇë½Ì´ó¼ÒÁË¡£
ÏȸÐлŶ£¡
ÎÒÒª¿Ï¶¨µÄ´ð°¸¹þ£¬ÔÚÏߵȡ¡
ºÃµÄ лл2Â¥ºÃÓÑ£¡
½áÌù£¡
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......