ORACLE ³£ÓÃ×Ö·ûº¯Êý
1.LOWER(str) Ç¿ÖÆÐ¡Ð´
2.UPPER(str) Ç¿ÖÆ´óд
3.INITCAP(str) ÿ¸öµ¥´ÊÊ××Öĸ´óд
ʾÀý£º
SQL> select initcap('my_boy') from dual; --·µ»Ø"My_Boy"
×¢Ò⣺µ¥´ÊÖ®¼äÓÃÏ»®Ïߣ¨"_"£©·Ö¸î
4.CONCAT(str1,str2£©Á¬½Óº¯Êý,Á¬½Óstr1ºÍstr2×Ö·û´®
5.SUBSTR(string,a[,b])·µ»ØstringµÄÒ»²¿·Ö£¬aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó×Ö·ûλÖÃa¿ªÊ¼£¬³¤Îªb¸ö×Ö·û¡£Èç¹ûaÊÇ0£¬ÄÇËü¾Í±»ÈÏΪÊÇ1£¨×Ö·û´®µÄ¿ªÊ¼Î»Öã©¡£Èç¹ûaÊÇÕýÊý£¬ÄÇô×Ö·û´Ó×ó±ß¿ªÊ¼Êý¡£Èç¹ûÊǸºÊý£¬Ôò´ÓSTRINGµÄĩβ¿ªÊ¼£¬´ÓÓÒ±ßÊý¡£Èç¹ûb²»´æÔÚ£¬ÄÇôȱʡÊÇÕû¸ö×Ö·û´®¡£Èç¹ûbСÓÚ1£¬½«·µ»ØNULL¡£Èç¹ûa»òbʹÓÃÁ˸¡µãÊý£¬ÄÇô¸ÃÊýÖµÊ×Ïȱ»½ÚÈ¡³ÉÒ»¸öÕûÊý£¬·µ»ØÀàÐÍÓëSTRINGÏàͬ¡£
ʾÀý£º
SQL> select substr('abcde',1,2) from dual; --·µ»Ø"ab"
5.LENGTH(str£©·µ»ØstringµÄ³¤¶È¡£ÒòΪCHARÀàÐ͵ÄÖµÊÇÌî³ä¿Õ¸ñµÄ£¬ËùÒÔÈç¹ûstringÊÇCHARÊý¾ÝÀàÐÍ£¬ÄÇôĩβµÄ¿Õ¸ñËãÔÚ³¤¶ÈÖ®ÄÚ¡£Èç¹ûstringÊÇNULL£¬º¯Êý·µ»ØNULL¡£
ʾÀý£º
SQL> select length('a b c ') from daul; --·µ»Ø6
SQL> select length(null) from dual; --·µ»ØNULL
6.INSTR(string1,string2[,a][,b]) ·µ»Østring1Öаüº¬string2µÄλÖá£aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó×ó±ß¿ªÊ¼É¨Ãèstring1,ÆðʼλÖÃÊÇA¡£Èç¹ûAΪ¸ºÊýÄÇô´ÓÓұ߿ªÊ¼É¨Ãè¡£µÚB´Î³öÏÖµÄλÖý«±»·µ»Ø¡£AºÍBȱʡ¶¼Îª1£¬¼´·µ»ØÔÚstring1ÖеÚÒ»´Î³öÏÖstring2µÄλÖá£Èç¹ûstring2ÔÚAºÍBµÄ¹æ¶¨ÏÂûÓÐÕÒµ½ÄÇô¾Í·µ»Ø0¡£Î»ÖõļÆËãÊÇÏà¶ÔÓÚstring1µÄ¿ªÊ¼Î»Öõ쬶ø²»¹ØAºÍBµÄȡֵ¡£
ʾÀý£º
SQL> select instr('abcbe','b',1,2) from dual; --·µ»Ø4
SQL> select instr('abcbe','b',3) from dual; --·µ»Ø4
SQL> select instr('abcbe','d') from dual; --·µ»Ø0
7.LPAD£¨ÁÐÃû,Êý×Ö,‘Òª²¹ÉϵÄ×Ö·û'£©×ó²¹Î»
ʾÀý£º
SQL> select lpad('abc',5,'#') from dual; --·µ»Ø##abc
8.RPAD£¨ÁÐÃû£¬Êý×Ö£¬'Òª²¹ÉϵÄ×Ö·û'£©ÓÒ²¹Î»
ʾÀý£º
SQL> select rpad('abc',5,'#') from dual; --·µ»Øabc##
9.TRIM('child_str’from‘parents_str') ½«Á¬Ðø×Ó´®£¨Ö»ÄÜÓÐÒ»¸ö×Ö·û£©´ÓÖ÷´®µÄÁ½±ß½ØÈ¡³öÀ´£¬Çø·Ö´óСд¡£Ä¬ÈÏΪ½ØÈ¡¿Õ¸ñ¡£Trim(str)È¥µôstrǰºó¿Õ¸ñ¡£
ʾÀý£º
SQL> select trim('a' from 'aba') from dual; --·µ»Øb
SQL> select trim(' bbb ') from dual; --·µ»Øbbb
10.LTRIM(str) ×ó½ØÈ¡
11.RTRIM(str) ÓÒ½ØÈ¡
12.REPLACE(x,y[,z]) ·µ»Ø
Ïà¹ØÎĵµ£º
1¸öʵÀý
create table tjob2(tt date);
´´½¨Ò»¸ö´æ´¢¹ý³Ì
create or replace procedure t26 is
begin
insert into tjob2 values(sysdate);
commit;
end t26;
´´½¨job£¬Ã¿·ÖÖÓÖ´ÐÐÒ»´Î
SQL> declare
2 tjob number;
3 begin
4 sys.dbms_jo ......
±¾ÎÄÀ´×Ôhttp://www.cnblogs.com/rootq/articles/1177562.html
Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ ......
Most of admins neglect setting password on TNSlsnr Clients for Oracle databases. Oracle ensures that you can either connect to TNSlsnr on a localhost or through mapping to a remote Oracle database using .ora files.
This is not the case anymore Based on Jwa perl client.
This client is a FULL clie ......
1¡£»ù±¾¸ÅÄ
Êý¾Ý¿âÁ¬½Ó´®Ö÷ÒªÓÃÓÚ½¨Á¢¶ÔÔ¶³ÌÊý¾Ý¿âµÄ·ÃÎÊ·½·¨£¬¿ÉÒÔÖ±½Ó¶ÁȡԶ³ÌOracleµÄÊý¾Ý£¬»òÕßÖ±½ÓÐ޸ġ£Êý¾Ý¿âÁ¬½Ó´®¿ÉÒÔÊǹ«ÓÃÁ¬½ÓPUBLIC»òÕß˽ÓÐÁ¬½ÓPRIVATE¡£ÕâÒ»µãºÍͬÒå´ÊºÜÏàÏñ¡£
1¡£´´½¨Óï·¨£º
CREATE DATABASE LINK TEST CONNECT TO USERNAME IDENTIFIED BY PASSWORD
USING 'CONNECT_STRING ......