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

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
-- -
ÕÔ A
3. CONCAT
Á¬½ÓÁ½¸ö×Ö·û´®;
SQL> select concat(010-,88888888)||ת23 ¸ßǬ¾ºµç»° from dual;
¸ßǬ¾ºµç»°
----------------
010-88888888ת23
4. INITCAP
·µ»Ø×Ö·û´®²¢½«×Ö·û´®µÄµÚÒ»¸ö×Öĸ±äΪ´óд;
SQL> select initcap(smith) upp from dual;
UPP
-----
Smith
5.INSTR(C1,C2,I,J)
ÔÚÒ»¸ö×Ö·û´®ÖÐËÑË÷Ö¸¶¨µÄ×Ö·û,·µ»Ø·¢ÏÖÖ¸¶¨µÄ×Ö·ûµÄλÖÃ;
C1 ±»ËÑË÷µÄ×Ö·û´®
C2 Ï£ÍûËÑË÷µÄ×Ö·û´®
I ËÑË÷µÄ¿ªÊ¼Î»ÖÃ,ĬÈÏΪ1
J ³öÏÖµÄλÖÃ,ĬÈÏΪ1
SQL> select instr(oracle traning,ra,1,2) instring from dual;
INSTRING
---------
9
6.LENGTH
·µ»Ø×Ö·û´®µÄ³¤¶È;
SQL> select name,length(name),addr,length(addr),sal,length(to_char(sal)) from gao.nchar_tst;
NAME LENGTH(NAME) ADDR LENGTH(ADDR) SAL LENGTH(TO_CHAR(SAL))
------ ------------ ---------------- ------------ --------- --------------------
¸ßǬ¾º 3 ±±¾©Êк£¶§Çø 6 9999.99 7
7.LOWER
·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
SQL> select lower(AaBbCcDd)AaBbCcDd from dual;
AABBCCDD
--------
aabbccdd
8.UPPER
·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·û´óд
SQL> select upper(AaBbCcDd) upper from dual;
UPPER
--------
AABBCCDD
9.RPADºÍLPAD(Õ³Ìù×Ö·û)
RPAD ÔÚÁеÄÓÒ±ßÕ³Ìù×Ö·û
LPAD ÔÚÁеÄ×ó±ßÕ³Ìù×Ö·û
SQL> select lpad(rpad(gao,10,*),17,*)from dual;
LPAD(RPAD(GAO,1
-----------------
*******gao*******
²»¹»×Ö·ûÔòÓÃ*À´ÌîÂú
10.LTRIMºÍRTRIM
LTRIM ɾ³ý×ó±ß³öÏÖµÄ×Ö·û´®
RTRIM ɾ³ýÓұ߳öÏÖµÄ×Ö·û´®
SQL> select ltrim(rtrim( gao qian jing , ), ) from dual;
LTRIM(RTRIM(
-------------
gao qian jing
11.SUBSTR(string,start,count)
È¡×Ó×Ö·û´®,´Óstart¿ªÊ¼,È¡count¸ö
SQL> select substr(13088888888,3,8) from dual;
SUBSTR(
--------
08888888
12.REPLACE(string,s1,s2)
string Ï£Íû±»Ìæ»»µ


Ïà¹ØÎĵµ£º

oracle ±Ê¼Ç V Ö®´¥·¢Æ÷ (TRIGGER)

 ´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
      Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......

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ÖеÄË÷Òý×éÖ¯±í

 Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊÇ°´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÈçÏÂͼËùʾ£¬ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø ......

ORACLE ÏëÇå³þÁËÔÙ×ö£¬Òª½÷É÷Щ¡¡ÐÖµÜ

 ÐÇÆÚÒ» ·¢ÏÖÒ»¸ö±íÓкܶàÖظ´Êý¾Ý Ëæ»úʹÓÃɾ³ýÖظ´Êý¾ÝµÄÓï¾ä¡£
ÐÇÆÚ¶þ ·¢ÏÖ ÕâÓï¾äÅÜÁ˺ܾö¼Ã»ÅÜÍ꣬13¸öСʱÁË£¡Ö»²»¹ýɾ³ý10¸öÔµÄÊý¾Ý¶øÒÑ
ÒÀÈ»¶ÏÁËËü£¬¿ÉËü»Ø¹ö»¨ÁË4¸öСʱ£¬ÉÏÎçÓ°ÏìÁËÊý¾Ý¿âµÄ·þÎñËÙ¶ÈÁË¡£
È»ºóÒ»¸öÔÂÒ»¸öÔ¼ì²éÖظ´Êý¾ÝµÄ·¶Î§£¬×îºó¶¨Î»µ½9Ôµ½10Ô¡£É¾³ýËü£¬ÓÃÄÇÌõÓï¾äºÜÂý£¬Ò»¸öСʱºó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ