Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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À


Ïà¹ØÎĵµ£º

110¸öoracle³£Óú¯Êý×ܽá

1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- ......

Oracle ADF ¼ò½é

ADFÊÇ£¨Application Development Framework£©µÄ¼ò³Æ£¬ËüµÄÇ°ÉíÊÇBC4J¡£ ¹âÌýÕâ¸öÃû×Ö¾ÍÖªµÀËüÊÇÒ»¸öend-to-endµÄ¿ò¼Ü¡£ºÍSpringÒ»ÑùËüÔÚÆóÒµÓ¦Óüܹ¹µÄÿһ¸ö²ã´Î¶¼ÌṩÁËËüµÄÖ§³Ö¡£ADFµÄ¼Ü¹¹ÈçÏÂͼËùʾ£º
ÔÚÿһ²ãADF¶¼ÓÐËüµÄһЩ×é¼þ¡£ÎÒÕâ´ÎÖ÷ÒªÏë½²½²ADFµÄdata binding£¬ÒòΪËü¸ôÀëÁËÒµÎñÂß¼­²ãºÍweb²ã£¬Ê¹µÃÁ½¸ö²ã´Î ......

Oracle JDBC ×Ô´øÁ¬½Ó³Ø

 http://www.diybl.com/course/3_program/java/javajs/2008429/111906.html
Èç¹ûҪʹÓóصĻ°,¾Í±ØÐëʹÓÃOracleConnectionCacheImpl,¹²ÓÐÈýÖֳصIJßÂÔ:
DYNAMIC_SCHEME(ÊǶ¯Ì¬Ôö¼Ó.ÓÃÍêÈç¹û³¬¹ýÉÏÏÞÔò¹Øµô)
The cache will create connections above the specified maximum limit
when necessary   but ......

Oracle»ù´¡ÖªÊ¶

Q1.ÔõÑù´´½¨±í£¿
Q2.ÔõÑùɾ³ý±í£¿
Q3.ÔõÑù´´½¨ÊÓͼ£¿
Q4.ÔõÑùɾ³ýÊÓͼ£¿
Q5.ÔõÑù¸ø±íÌí¼Ó×ֶΣ¿
Q6.ÔõÑùɾ³ý±íÖÐij¸ö×ֶΣ¿
Q7.ÔõÑù¸øij¸ö×Ö¶ÎÌí¼ÓÔ¼Êø£¿
Q8.ÔõÑùÈ¥³ýij¸ö×Ö¶ÎÉϵÄÔ¼Êø£¿
Q9.ÔõÑù¸ø±í¼ÓÉÏÖ÷¼ü£¿
Q10.ÔõÑùɾ³ý±íµÄÖ÷¼ü£¿
Q11.ÔõÑù¸ø±íÌí¼ÓÒ»¸öÍâ¼ü£¿
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ