Oracle Êý¾Ý¿âµÄ°²×°
×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖ֨װ£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔǰÔÚÐ¶ÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ÓµÄ×¢Òâ¿©¡£
ÏÖÔÚÖÕÓڴ󹦸æ³É£¬ºÃÏë¿Þ£¡ ÕâÊÇÎÒµÚÒ»´ÎÕâÑùÏàÐÅ×Ô¼º£¬Ð»Ð»ÍøÓѵÄһЩ°ï£¬http://blog.csdn.net/xiaoyao6650/archive/2009/03/15/3989484.aspx£¬½ñÌìÓÖ×°ÁËVS2008£¬ÀÏÊÇÌø³öWEB×é¼þ°²×°Ê§°Ü£¬ÆøËÀÁË£¬
ÏÖÔÚÖÕÓÚ¸ãºÃÁË£¬ÔÀ´ÊÇoffice_zh-cnµÄÎÊÌ⣬ÖÕÓڵõ½Á˽â¾ö¡£
ÖÐÎç·¸Á˸ö´íÎó£¬ÌýÐÅÍøÓѵķ½·¨£¬ÐÞ¸ÄÁËÓû§µÄÕË»§£¬×îºó½øÈëF8²ÅµÃ½â¾ö£¬¿´À´µÃ×Ô¼º¶à¶¯¶¯ÄÔ×Óȥ˼¿¼°¡£¡
¾ÀúÁËÕâЩÊÂÇ飬¸ü¼Ó¼á¶¨ÁË×Ô¼ºÒª×ߵķ£¬Chang,ÎÒÃÇÒ»ÆðŬÁ¦°É£¡ÏàÐÅ£¬ÎÒÏàÐÅÎÒÐеģ¬ÄãÒ²Ò»¶¨»áµÄ£¬²»ÊǵÄô£¬MyLove !
Ïà¹ØÎĵµ£º
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ......
JobµÄ²ÎÊý£º
Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ ......
INTERVAL YEAR TO MONTHÊý¾ÝÀàÐÍ
OracleÓï·¨:
INTERVAL 'integer [- integer]' {YEAR | MONTH} [(precision)][TO {YEAR | MONTH}]
¸ÃÊý¾ÝÀàÐͳ£ÓÃÀ´±íʾһ¶Îʱ¼ä²î, ×¢Òâʱ¼ä²îÖ»¾«È·µ½ÄêºÍÔÂ. precisionΪÄê»òÔµľ«È·Óò, ÓÐЧ·¶Î§ÊÇ0µ½9, ĬÈÏֵΪ2.
eg:
INTERVAL '123-2' YEAR(3) TO MONTH & ......
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£¨×ªÌû£©
Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora
Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
  ......
ÔÚ°²×°ÍêOracle
10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
error£º the account is locked
È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
2.´ËÓû§±»¹ÜÀíÔ±ÊÖ¹¤Ëø¶¨ ......