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

ORACLE³£ÓÃת»»º¯Êý¡¢ÊýÖµº¯Êý¡¢×Ö·û´®º¯Êý½éÉÜ

±¾ÎÄÀ´×Ô£ºWWW.NC21.CN  ÐÂÊÀ¼Íƽ̨Íø  
±¾Îĸü¶à½«»á½éÉÜÈý˼ÔÚÈÕ³£Öо­³£»áÓõ½µÄ£¬»òÕßËäÈ»ºÜÉÙÓõ½£¬µ«ÊǸоõͦÓÐÒâ˼µÄһЩº¯Êý¡£·Ö¶þÀà½éÉÜ£¬·Ö±ðÊÇ£º
¡¡¡¡ÖøÃûº¯Êýƪ¡¡£­¾­³£Óõ½µÄº¯Êý
¡¡¡¡·ÇÖøÃûº¯Êýƪ£­¼´ËäÈ»ºÜÉÙÓõ½£¬µ«Ä³Ð©Çé¿öÏÂÈ´ºÜʵÓÃ
¡¡¡¡×¢£ºN±íʾÊý×ÖÐÍ£¬C±íʾ×Ö·ûÐÍ£¬D±íʾÈÕÆÚÐÍ£¬[]±íʾÄÚÖвÎÊý¿É±»ºöÂÔ£¬fmt±íʾ¸ñʽ¡£
¡¡¡¡µ¥Öµº¯ÊýÔÚ²éѯÖзµ»Øµ¥¸öÖµ£¬¿É±»Ó¦Óõ½select£¬where×Ӿ䣬start withÒÔ¼°connect by ×Ó¾äºÍhaving×Ӿ䡣
¡¡¡¡(Ò»).ÊýÖµÐͺ¯Êý(Number Functions)
¡¡¡¡ÊýÖµÐͺ¯ÊýÊäÈëÊý×ÖÐͲÎÊý²¢·µ»ØÊýÖµÐ͵ÄÖµ¡£¶àÊý¸ÃÀຯÊýµÄ·µ»ØÖµÖ§³Ö38λСÊýµã£¬ÖîÈ磺COS, COSH, EXP, LN, LOG, SIN, SINH, SQRT, TAN, and TANH Ö§³Ö36λСÊýµã¡£ACOS, ASIN, ATAN, and ATAN2Ö§³Ö30λСÊýµã¡£
1¡¢MOD(n1,n2) ·µ»Øn1³ýn2µÄÓàÊý£¬Èç¹ûn2=0Ôò·µ»Øn1µÄÖµ¡£
¡¡¡¡ÀýÈ磺SELECT MOD(24,5) from DUAL;
2¡¢ROUND(n1[,n2]) ·µ»ØËÄÉáÎåÈëСÊýµãÓÒ±ßn2λºón1µÄÖµ£¬n2ȱʡֵΪ0£¬Èç¹ûn2Ϊ¸ºÊý¾ÍÉáÈ뵽СÊýµã×ó±ßÏàÓ¦µÄλÉÏ(ËäÈ»oracle documentsÉÏÌáµ½n2µÄÖµ±ØÐëΪÕûÊý£¬ÊÂʵÉÏÖ´ÐÐʱ´Ë´¦µÄÅжϲ¢²»ÑϽ÷£¬¼´Ê¹n2Ϊ·ÇÕûÊý£¬ËüÒ²»á×Ô¶¯½«n2È¡Õûºó×ö´¦Àí£¬µ«ÊÇÎÒÎĵµÖÐÆäËüÌáµ½±ØÐëΪÕûµÄµØ·½ÐèÒªÌرð×¢Ò⣬Èç¹û²»ÎªÕûÖ´ÐÐʱ»á±¨´íµÄ)¡£
ÀýÈ磺SELECT ROUND(23.56),ROUND(23.56,1),ROUND(23.56,-1) from DUAL;
3¡¢TRUNC(n1[,n2] ·µ»Ø½Øβµ½n2λСÊýµÄn1µÄÖµ£¬n2ȱʡÉèÖÃΪ0£¬µ±n2ΪȱʡÉèÖÃʱ»á½«n1½ØβΪÕûÊý£¬Èç¹ûn2Ϊ¸ºÖµ£¬¾Í½ØβÔÚСÊýµã×ó±ßÏàÓ¦µÄλÉÏ¡£
ÀýÈ磺SELECT TRUNC(23.56),TRUNC(23.56,1),TRUNC(23.56,-1) from DUAL;
¡¡¡¡(¶þ).×Ö·ûÐͺ¯Êý·µ»Ø×Ö·ûÖµ(Character Functions Returning Character Values)
¸ÃÀຯÊý·µ»ØÓëÊäÈëÀàÐÍÏàͬµÄÀàÐÍ¡£
·µ»ØµÄCHARÀàÐÍÖµ³¤¶È²»³¬¹ý2000×Ö½Ú£»
·µ»ØµÄVCHAR2ÀàÐÍÖµ³¤¶È²»³¬¹ý4000×Ö½Ú£»
Èç¹ûÉÏÊöÓ¦·µ»ØµÄ×Ö·û³¤¶È³¬³ö£¬oracle²¢²»»á±¨´í¶øÊÇÖ±½Ó½Ø¶ÏÖÁ×î´ó¿ÉÖ§³Ö³¤¶È·µ»Ø¡£
 ·µ»ØµÄCLOBÀàÐÍÖµ³¤¶È²»³¬¹ý4G£»
¶ÔÓÚCLOBÀàÐ͵ĺ¯Êý£¬Èç¹û·µ»ØÖµ³¤¶È³¬³ö£¬oracle²»»á·µ»ØÈκδíÎó¶øÊÇÖ±½ÓÅ׳ö´íÎó¡£
1¡¢LOWER(c) ½«Ö¸¶¨×Ö·û´®ÄÚ×Ö·û±äΪСд£¬Ö§³ÖCHAR,VARCHAR2,NCHAR,NVARCHAR2,CLOB,NCLOBÀàÐÍ
¡¡¡¡ÀýÈ磺SELECT LOWER('WhaT is tHis') from DUAL;
2¡¢UPPER(c) ½«Ö¸¶¨×Ö·û´®ÄÚ×Ö·û±äΪ´óд£¬Ö§³ÖCHAR,VARCHAR2,NCHAR,NVARCHAR2,CLOB,NCLOBÀ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

VVR¶ÔOracleÊý¾Ý¿â½øÐÐÈÝÔÖ

   
Ëæ×ÅÈ«ÇòÐÅÏ¢»¯Ê±´úµÄµ½À´£¬ÐÅÏ¢Êý¾ÝÔ½À´Ô½³ÉΪÆóÒµ¹Ø×¢µÄ½¹µã£¬¼´ÔÚ¸÷ÖÖ×ÔÈ»ÔÖº¦»òÕßÈËΪÆÆ»µµÄÇé¿öÏ£¬ÈçºÎ±£Ö¤Éú²úÊý¾ÝµÄ°²È«ºÍ¹Ø¼üÒµÎñµÄ²»ÖжÏÔËÐС£
´«Í³µÄ±£»¤·½·¨ÀëÏß±¸·Ý¡¢±¸·Ý½éÖÊÒìµØ±£´æÔÚÒ»¶¨³Ì¶ÈÉÏ¿ÉÒÔ½â¾öÉÏÊöÎÊÌ⣬µ«ÎªÁËÄܹ»¶ÔÒµÎñϵͳÌṩ¸ü¸ßµÄʵʱÐԺͿɿ¿ÐÔ£¬±£Ö¤¹Ø¼üÒµÎñ7x24²» ......

Oracle Functionµ÷ÓÃjava´úÂë

 Ô­ÎÄ´«ËÍÃÅ£ºhttp://www.blogjava.net/improviser/archive/2008/12/07/244911.html
ÔÚǰһƪÎÄÕÂÖмòµ¥½éÉÜÁËJAVA³ÌÐòÈçºÎµ÷ÓÃOracle´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨³ÌÐò½á¹¹£¬ ±¾ÎĽ«½éÉÜJAVA¸úOracleµÄÁíÒ»ÖÖ¹Øϵ£¬¼´Í¨¹ýJAVA±àдOracle´æ´¢¹ý³Ì¡£ ͨ³£Çé¿öÏ£¬ÎÒÃǶ¼ÊÇʹÓÃOracleÊý¾Ý¿âϵͳÖеÄps/sqlÓï¾äÀ´Îªoracle±àд ......

oracle ÎïÀí¶Á,Âß¼­¶ÁµÄÀí½â

Ò».ÎïÀí¶Á(physical read)
µ±Êý¾Ý¿éµÚÒ»´Î¶ÁÈ¡µ½,¾Í»á»º´æµ½buffer cache ÖÐ,¶øµÚ¶þ´Î¶ÁÈ¡ºÍÐ޸ĸÃÊý¾Ý¿éʱ¾ÍÔÚÄÚ´æbuffer cache ÁË ÒÔÏÂÊÇÀý×Ó:
1.1 µÚÒ»´Î¶ÁÈ¡:
C:"Documents and Settings"Paul Yi>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 28 09:32:04 2008
Copyright (c) 19 ......

ORACLEÊý¾Ý¿âµÄÊý¾Ýµ¼Èë·½·¨

ÒÔ ÏÂÆßÖÖÊý¾Ýµ¼Èë·½·¨Äĸö×îÊÊÓÃÐèÒªÕë¶Ô¾ßÌåÇé¿ö¾ßÌå·ÖÎö£¬ÎÒÒ²¸½´øÁоÙÁËÓ°Ïìµ¼ÈëËٶȵĸ÷ÖÖÒòËع©Õå×á£ÎªÁ˱Ƚϸ÷ÖÖÊý¾Ýµ¼Èë·½·¨µÄЧ¹û£¬ÎÒ´´½¨ÁËʾÀý±í ºÍÊý¾Ý¼¯£¬²¢Óø÷ÖÖ·½·¨µ¼ÈëʾÀýÊý¾Ý¼¯À´¼ÆËã×ÜÌåµ¼Èëʱ¼äºÍµ¼Èë½ø³ÌÕ¼Óà CPU ʱ¼ä£¬ÕâÀïµÃ³öµÄʱ¼ä½ö¹©²Î¿¼¡£ÐèҪ˵Ã÷µÄÊÇ£¬½¨ÒéÄãʹÓà Oracle 9i ÆóÒµ°æÊý¾Ý¿â£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ