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

OracleÖÐto_char()²ÎÊýÏê½â

 1 -  /  ,  . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
 2 AD
A.D.  ¼´À­¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
 3 AM
A.M.  ÉÏÎçµÄ¼òд ,ͬpm, p.m. £¨ÏÂÎç) , ÖÐÎÄ»·¾³Êä³öΪÉÏÎ磨Èç¹ûÊÇÉÏÎ磩
 4 BC
B.C.  ËäÈ»±ê×¼µÄд·¨ÊÇB.c. (cСд£© »òÕßBC,ºÃÔÚOracle²»½²¾¿Õâ¸ö¡£±íʾ¹«ÔªÇ°
 5 CC
SCC  ·µ»ØÊÀ¼Í£¬ÒÔ°¢À­²®Êý×Ö±íʾ
Èç¹ûÄêµÄºóÁ½Î»½éÓÚ01-99ÄÇô£¬·µ»ØÇ°Á½Î»+1£¬·ñÔò·µ»ØÇ°Á½Î»
 6 D  Ò»ÖÜÖ®ÖеÄijÌ죬·µ»ØµÄÊÇÐòºÅ1-7
 7 DAY  Ò»ÖÜÖ®ÖеÄijÌ죬²»¹ý·µ»ØµÄÊÇÐÇÆÚ¼¸¶øÒÑ£¬ÕâºÍÓïÑÔÉèÖÃÓйØϵ£¬ÔÚÖйú»·¾³ NLS_DATE_LANGUAGE=SIMPLIFIED CHINESE £¬ÓÃÐÇÆÚÒ»µ½ÐÇÆÚÌì±íʾ
 8 DD Ô·ÝÖеÄijÌì(1-31)
 9 DDD  Äê·ÝÖеÄijÌ죨1-366£©
 10 DL 'DL' ·µ»Ø³¤µÄÈÕÆÚ¸ñʽ¡£Êܵ½NLS_TERRITORY,NLS_LANGUAGE²ÎÊý¿ØÖÆ¡£Àý 2008Äê4ÔÂ28ÈÕ ÐÇÆÚÒ»
ÏÞÖÆ£º³ýÁËDL£¬ÆäËüʲôµÄ¶¼²»ÄÜÉèÖá£
 11 DS  ·µ»Ø¶ÌµÄÈÕÆÚ¸ñʽ¡£Êܵ½NLS_TERRITORY,NLS_LANGUAGE²ÎÊý¿ØÖÆ¡£ ÀýÈç 2008-04-28
ÏÞÖÆ£º³ýÁËDL£¬ÆäËüʲôµÄ¶¼²»ÄÜÉèÖá£
 12 DY  ÈÕÆڵļò³Æ£¬¾ÍÊÇÐÇÆÚ¼¸£¨µ±È»ÕâÖ¸µÄÊÇÖйú»·¾³ÏÂ)
 13 E  ¼ÍÔª¼ò³Æ£¬µ«ÊÇÖ»ÊʺÏÒÔϼ¯ÖÐÈÕÀú£ºÈÕ±¾»ÊÊÒ£¬ÖлªÃñ¹ú,Ì«¹ý·ðÀú
 14 EE  ¼ÍԪȫ³Ì£¬ÊʺÏÇé¿öͬE
 15 FF [1..9]  ¾ÍÊǺÁÃë,Èç¹û²»¸üÉÏÊý×Ö¾ÍÊÇÓÃĬÈϵľ«¶È¡£
Ö»ÄÜÓÃÓÚtimestampÀàÐ͵ġ£
 16 FM  ÖµµÃ×¢ÒâµÄÒ»¸öº¯Êý£º²»·µ»ØÈκÎÄÚÈÝ¡£
Óе㲻Ã÷°×oracleΪʲôÉèÖÃÕâ¸ö¶«Î÷.
 17 FX  ͬÉÏ
 18 HH  ±íʾСʱ£¬Îª12СʱÖÆ£¬Í¬hh12(1-12)
 19 HH12  ±íʾСʱ£¬Îª12СʱÖÆ(1-12)
 20 HH24  ±íʾСʱ£¬Îª24СʱÖÆ£¨0-23£©
 21 IW  ISO±ê×¼µÄÐÇÆÚÐòºÅ(1-52,»òÕß1-53£©
 22
IYYY
IYY
IY
I
 IYY,IY,I, ISOÄê(4룩µÄ4,3£¬2£¬1λÊý×Ö(µ¹Êý£©
to_char(to_date(21120401,'yyyymmdd'),'iyyy, iyy,iy,i')=2112, 112,12,2
 23 J  ÈåÂÔÈÕ(¶àÓÃÓÚÌìÎĵÄÒ»ÖÖÈÕÀú£©,´Ó¹«ÔªÇ°4712ÄêÒ»ÔÂÒ»ÈÕËãÆ𣬵óöµÄ½á¹ûÊǸöÕûÊý£¬Ëã·¨´óÌåΪ £¨¹«ÔªÈÕÆÚ+4712£©*ÈåÂÔÈÕÀúÄ


Ïà¹ØÎĵµ£º

OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È

OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
1¡¢Ç°ÑÔ
    Ä¿Ç°ËùÓÐʹÓÃOracle×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
    µ±È»ÔÚOracleÖд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ«Êǵ±Äã·¢ÏÖÄãµÄÓ¦ÓÃÓжàÕűí¹ØÁªµÄʱºò£¬²¢ÇÒÕâЩ±í´ó²¿·Ö¶¼ÊÇ±È½Ï ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç6

Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç7

oracle±í·ÖÇø
oracleÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼­²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
......

±±´óÇàÄñoracleѧϰ±Ê¼Ç8 9


±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû; ......

½ñÌìoracle DBA½ç´óʦ¼¶ÈËÎï¸Ç¹úÇ¿ÏÈÉúÀ´ÎÒÃǹ«Ë¾

      2010Äê3ÔÂ5ÈÕ£¬ËäÈ»º®·ç´Ì¹Ç£¬µ«ÒÀÈ»µ²²»×¡¹«Ë¾Í¬ÊºÍÎÒ¹¤×÷µÄÈÈÇé.µÎ´ð¡¢µÎ´ð,ͬÊÂÊÖ»úÏìÁË£¬ÀÏ×ܸøËû´òµç»°£¬Ëµ¹ã¶«ÁªÍ¨ÍøÓÅƽ̨Êý¾Ý¿â³öÏÖÎÊÌ⣬ÓÉÓÚÊý¾ÝÁ¿È·Êµ¹ý´ó£¬Í¬ÊÂÒÔÇ°Ò²´¦Àí¹ýÄDZߵÄÎÊÌ⣬Ö÷ÒªÊÇËùÓÐÊý¾ÝÁ¿´óµÄ±íÿ¸ôÒ»Ì콨Á¢Ò»¸öË÷Òý£¬ÕâÑù²éѯÊý¾ÝËٶȱȽϿ졣µ«ÊǽøÐÐÊý¾Ý»ã× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ