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

Oracle TO_DATE,to_char

OracleÖÐTO_DATE¸ñʽ
url:http://www.cnblogs.com/ajian/archive/2009/03/25/1421063.html
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê                ÏÔʾֵ:07
        yyy three digits ÈýλÄê                ÏÔʾֵ:007
        yyyy four digits ËÄλÄê                ÏÔʾֵ:2007
           
        Month:     
        mm    number     Á½Î»Ô              ÏÔʾֵ:11
        mon    abbreviated ×Ö·û¼¯±íʾ          ÏÔʾֵ:11ÔÂ,ÈôÊÇÓ¢Îİæ,ÏÔʾnov    
        month spelled out ×Ö·û¼¯±íʾ          ÏÔʾֵ:11ÔÂ,ÈôÊÇÓ¢Îİæ,ÏÔʾnovember
         
        Day:     
        dd    number         µ±Ôµڼ¸Ìì        ÏÔʾֵ:02
        ddd    number         µ±ÄêµÚ¼¸Ìì        ÏÔʾֵ:02
        dy&


Ïà¹ØÎĵµ£º

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨1£©£ºOracleµÄ»ù±¾¸ÅÄî

ÏÈÀ´Á˽âϼ¸¸öÓ¢Îĵļò³Æ£¬ÔÚÒÔºó¾­³£»á¼ûµ½¡£
¶ÔÏó¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨Object Relational Database Management System£¬¼ò³ÆORDBMS£©
¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨Relational Database Management System£¬¼ò³ÆRDBMS£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£¬¼ò³ÆDBMS£©
½á¹¹»¯²éѯÓïÑÔ£¨Structured Query Langua ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨3£©

ÊÖ¶¯½¨¿âÆäʵҲ¿ÉÒÔ·ÖΪÁ½ÖÖ£¬Ò»ÖÖÊDz»Ê¹ÓÃOMF´´½¨£¬ÁíÒ»ÖÖÊÇʹÓÃOMF´´½¨¡£
Ò»¡¢²»Ê¹ÓÃOMFÊÖ¶¯´´½¨Êý¾Ý¿â
1¡¢´´½¨Îļþ¼Ð¡££¨¸ù¾Ý¸Õ²Å/ora01/db/oracle/admin/ocpÖеÄĿ¼£¬ÎÒÃÇҲͬÑù´´½¨£©
?[Copy to clipboard]View Code BASH
$ mkdir /ora01/db/oracle/admin/mydb
$ cd /ora01/db/oracle/admin/mydb
$ mkdir bdum ......

ORACLEÈëÃÅÊé¼®ÍÆ¼ö


OracleÈëÃÅÊé¼®ÍÆ¼ö
ºÜ¶àÅóÓÑÒªÎÒ°ïÃ¦ÍÆ¼öÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²á ......

oracle´íÎó˵Ã÷

ORA-00001: Î¥·´Î¨Ò»Ô¼ÊøÌõ¼þ (.)
ORA-00017: ÇëÇó»á»°ÒÔÉèÖøú×Ùʼþ
ORA-00018:
³¬³ö×î´ó»á»°Êý
ORA-00019: ³¬³ö×î´ó»á»°Ðí¿ÉÊý
ORA-00020: ³¬³ö×î´ó½ø³ÌÊý ()
ORA-
00021: »á»°¸½ÊôÓÚÆäËüijЩ½ø³Ì£»ÎÞ·¨×ª»»»á»°
ORA-00022: ÎÞЧµÄ»á»° ID£»·ÃÎʱ»¾Ü¾ø
ORA-00023:
»á»°ÒýÓýø³Ì˽ÓÃÄڴ棻ÎÞ·¨·ÖÀë»á» ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨20£©£º»Ö¸´OracleÊý¾Ý¿â

1¡¢»Ö¸´½á¹¹Óë½ø³Ì
ÔÚ½éÖÊʧ°Üºó£¬¸ù¾ÝÊÜËðÎļþµÄÀàÐÍ£¬´æÔÚ²»Í¬µÄ»Ö¸´·½·¨¡£Êý¾Ý¿âÓÉ¿ØÖÆÎļþ¡¢Áª»úÖØ×öÈÕÖ¾ÎļþÒÔ¼°Êý¾ÝÎļþ×é³É¡£Èç¹û¸´ÓÃÁË¿ØÖÆÎļþ»òÁª»úÖØ×öÈÕÖ¾Îļþ£¬ÄÇô»Ö¸´ÊÜËðµÄÕâЩÎļþÊ®·ÖÈÝÒס£
¶ÔÓÚÊÜËðµÄ¿ØÖÆÎļþ£¬¿ÉÒÔ½«ÆäÌæ»»ÎªÄ³¸ö¸´Óø±±¾£¬Ò²¿ÉÒÔʹÓÃCREATE CONTROLFILEÃüÁîÖØ½¨¡£
ÊÜËðµÄÁª»úÖØ×öÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ