´«ÖDz¥¿Í 2010 1 19Ê®°Ë¡¢ORACLE(2)_ µ¥Ðк¯Êý
¶ÔÿһÐÐÊäÈëÖµ½øÐмÆË㣬µÃµ½ÏàÓ¦µÄ¼ÆËã½á¹û£¬·µ»Ø¸øÓû§£¬Ò²¾ÍÊÇ˵£¬Ã¿ÐÐ×÷Ϊһ¸öÊäÈë²ÎÊý£¬¾¹ýº¯Êý¼ÆËãµÃµ½Ã¿ÐеļÆËã½á¹ûÊǵ¥Ðк¯Êý¡£
Ò»¡¢×Ö·ûº¯Êý
1¡¢×Ö·û´®´óСдת»»
(1)LOWER (strexp) ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
(2)UPPER (strexp) ·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·û´óд
(3)INITCAP(strexp) ½«×Ö·û´®µÄ(ÿ¸öµ¥´ÊµÄ)µÚÒ»¸ö×Öĸ±äΪ´óд,ºóÃæµÄСд
2¡¢×Ö·û´¦Àíº¯Êý
(1)CONCAT(strexp, strexp): Á¬½ÓÁ½¸ö×Ö·û´®
(2)Substr(str,start_index,length) :´ÓÖ¸¶¨µÄλÖýØÈ¡Ö¸¶¨³¤¶ÈµÄ×Ö·û´®
(3)LENGTH(strexp):·µ»Ø×Ö·û´®µÄ³¤¶È
(4)INSTR(C1,C2,I,J):ÔÚÒ»¸ö×Ö·û´®ÖÐËÑË÷Ö¸¶¨µÄ×Ö·û,·µ»Ø·¢ÏÖÖ¸¶¨µÄ×Ö·ûµÄλÖÃ;
C1¡¢±»ËÑË÷µÄ×Ö·û´® ; C2¡¢Ï£ÍûËÑË÷µÄ×Ö·û´® ;I¡¢ËÑË÷µÄ¿ªÊ¼Î»ÖÃ,ĬÈÏΪ
1 ;J ¡¢Æ¥ÅäÐòºÅ,ĬÈÏΪ1.
ÀýÈ磺INSTR(‘CORPORATE FLOOR’,‘OR’, 3, 2)ÖУ¬Ô´×Ö·û´®Îª‘CORPORATE
FLOOR’, Ä¿±ê×Ö·û´®Îª‘OR’£¬ÆðʼλÖÃΪ3£¬È¡µÚ2¸öÆ¥ÅäÏîµÄλÖá£
(5)LPAD( string1, padded_length, [ pad_string ] ) ÔÚÁеÄ×ó±ßÕ³Ìù×Ö·û
ÆäÖÐstring1ÊÇÐèÒªÕ³Ìù×Ö·ûµÄ×Ö·û´®
padded_lengthÊÇ·µ»ØµÄ×Ö·û´®µÄÊýÁ¿£¬Èç¹ûÕâ¸öÊýÁ¿±ÈÔ×Ö·û´®µÄ³¤¶ÈÒª¶Ì£¬
lpadº¯Êý½«»á°Ñ×Ö·û´®½ØÈ¡³Épadded_length;
pad_stringÊǸö¿ÉÑ¡²ÎÊý£¬Õâ¸ö×Ö·û´®ÊÇÒªÕ³Ìùµ½string1µÄ×ó±ß£¬Èç¹ûÕâ¸ö²Î
Êýδд£¬lpadº¯Êý½«»áÔÚstring1µÄ×ó±ßÕ³Ìù¿Õ¸ñ¡£
(6)RPAD ÔÚÁеÄÓÒ±ßÕ³Ìù×Ö·û
¶þ¡¢Êý×Öº¯Êý
1¡¢Round£º´«»ØÒ»¸öÊýÖµ£¬¸ÃÊýÖµÊÇ°´ÕÕÖ¸¶¨µÄСÊýλÊý½øÐÐËÄÉáÎåÈëÔËËãµÄ½á¹û¡£
ROUND( number, decimal_places )
number : ÐèËÄÉáÎåÈë´¦ÀíµÄÊýÖµ£¬
decimal_places : ËÄÉáÎåÈë , СÊýÈ¡¼¸Î» ( Ô¤ÉèΪ 0 )
2¡¢TRUNCº¯Êý·µ»Ø´¦ÀíºóµÄÊýÖµ£¬Æ乤×÷»úÖÆÓëROUNDº¯Êý¼«ÎªÀàËÆ£¬Ö»ÊǸú¯ Êý²»¶ÔÖ¸¶¨Ð¡ÊýÇ°»òºóµÄ²¿·Ö×öÏàÓ¦ÉáÈëÑ¡Ôñ´¦Àí£¬¶øͳͳ½ØÈ¥¡£
3¡¢mod£¨number1£¬number2£©Á½¸öÊýÖµÏà³ý²¢·µ»ØÆäÓàÊý¡£ÔËËã·ûÖ´ÐÐ number
Ïà¹ØÎĵµ£º
1.»ñÈ¡µÇ½Óû§µÄÖ÷»úÃû
select sys_context('userenv','host') from dual;
2.»ñÈ¡µÇ½Óû§µÄIPµØÖ·
select sys_context('userenv','ip_address') from dual; ......
1.Ê×ÏÈ˵Ã÷һϣº
ÔÒòÊÇÒòΪÎÒÔÚ×öÕâ¸öÏîĿʱ£¬±»ÏÞÖƵÃÌ«¶à£¬weblogicºÍoracleµÄ°æ±¾²»Äܱ䣬ҪʹÓÃÔÀ´µÄ°æ±¾¡£
Òò´ËÄØ¡£²Ù×÷ÆðÀ´±È½ÏÂé·³¡£¶øÇÒ²»Äܸü¸ÄÔ±¾¹¤³ÌÀïÃæµÄJar°ü£¨ËüÀïÃæ´æÔÚÁËoracle14.jar°ü£¬µ«±È½Ï¾É£©
weblogic°æ±¾Îª£º8.14
oracle°æ±¾Îª£º9i
2.ÔÚÕâÀïÄØ£¬Ê¹ÓÃhibernate£¬ÒÔÁ÷µÄÐÎʽ¶ÁÈ¡µ½Êý¾ÝÀïÃæ ......
Oracle»¥»»×ܽá
1. ¶àÐл»³ÉÒ»ÐÐ
col1 col2 col1 col2
a 1
a 2 ת»»ºó ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......