oracle字符串/字符函数

INITCAP返回char，每个单词的首字母大写，所有其他字母小写。
SELECT INITCAP(‘wo shi shui, wo zai na’) “首字母大写” FROM DUAL;

SELECT INITCAP(‘WO SHI SHUI, WO ZAI NA’) “首字母大写” FROM DUAL;

LOWER：所有字母均为小写
SELECT LOWER (‘WO SHI SHUi, WO Zai na’) “所有字母均为小写” FROM DUAL;

SELECT LOWER (‘WO SHI SHUi, WO Zai na 123’) “所有字母均为小写” FROM DUAL;

UPPER：所有字母均大写。
SELECT UPPER(‘wo shi shui, wo zai na’) “所有字母均大写” FROM DUAL;

LENGTH：字符串的长度
SELECT LENGTH(‘woshishuiwozaina’) “字符串的长度” FROM DUAL;

SELECT LENGTH(‘wo shi shui wo zai na’) “字符串的长度” FROM DUAL;

SELECT LENGTH(’ ‘) “字符串的长度” FROM DUAL;

SELECT LENGTH(’’) “字符串的长度” FROM DUAL;

SELECT LENGTH(‘李’) “字符串的长度” FROM DUAL;

VSIZE：返回字节数
SELECT VSIZE(‘李’) “字符串的长度” FROM DUAL;

SELECT VSIZE(‘a’) “字符串的长度” FROM DUAL;

CONCAT：函数使您可以将两个字符串连接在一起
SELECT CONCAT(CONCAT(‘A’, ‘B’),‘C’) “连接字符串” FROM DUAL;

连接两个以上的值
SELECT CONCAT(CONCAT(CONCAT(‘A’, ‘B’),‘C’),‘D’) “连接字符串” FROM DUAL;

SELECT CONCAT(‘Li’‘Hao’,‘Lian Xi’)“连接单引号” FROM DUAL;

||
SELECT ‘a’ || ‘b’ || ‘c’ || ‘d’ “连接字符串” FROM DUAL;

SELECT ‘a’||‘b’||‘c’||‘d’ “连接字符串” FROM DUAL;

SELECT ‘Li’ || ’ ’ || ‘Hao’ “连接字符串” FROM DUAL;

SELECT ‘Li’‘Hao’ || ‘Lian Xi’ “连接字符串” FROM DUAL;

LPAD：将字符填充到的字符串（左侧）。
SELECT LPAD(‘神’,8) “左填充*.” FROM DUAL;

SELECT LPAD(‘神’,8,’.’) "左填充." FROM DUAL;

SELECT LPAD(‘神’,8,’.’) "左填充." FROM DUAL;

SELECT LPAD(‘神’,16,’_..’) “左填充” FROM DUAL;

SELECT LPAD(‘ceshi’,2) “左填充*.” FROM DUAL;

SELECT LPAD(‘aaaa’, 8, ‘0’) “左填充*.” FROM DUAL;

RPAD：将字符填充到的字符串（右侧）。
SELECT RPAD(‘神’,8) “右填充” FROM DUAL;

SELECT RPAD(‘神’,16,’_..’) “右填充” FROM DUAL;

SELECT RPAD(‘aaaa’, 8, ‘0’) “右填充” FROM DUAL;

SELECT RPAD(‘ceshi’,2) “右填充” FROM DUAL;

LTRIM从左端删除中char包含的所有字符.

SELECT LTRIM(’ ceshi’) “左端删除” FROM DUAL;

SELECT LTRIM(‘000123’, ‘0’) “左端删除” FROM DUAL;

SELECT LTRIM(‘123123eshi123’, ‘123’) “左端删除” FROM DUAL;

SELECT LTRIM(‘1340ceshi’, ‘0123456789’) “左端删除” FROM DUAL;

SELECT LTRIM(‘xxyyxzyxyyxLH’, ‘xyz’) “左端删除” FROM DUAL;

RTRIM:从端删除中char包含的所有字符
SELECT RTRIM(‘123000’, ‘0’) “右端删除” FROM DUAL;

SELECT RTRIM(‘LHxyxxyzyyyxx’, ‘xyz’) “右端删除” FROM DUAL;

SELECT RTRIM(‘1340ceshi0041’, ‘0123456789’) “右端删除” FROM DUAL;

SELECT RTRIM(‘000123000’, ‘0’) “右端删除” FROM DUAL;

SELECT RTRIM(’<=>BROWNING<=>’, ‘<>=’) “右端删除” FROM DUAL;

ASCII：返回代表指定字符的数字代码
SELECT ASCII(‘L’) “数字代码” FROM DUAL;

SELECT ASCII(‘l’) “数字代码” FROM DUAL;

SELECT ASCII(‘LH’) “数字代码” FROM DUAL;

SELECT ASCII(‘李’) “数字代码” FROM DUAL;

CHR：函数与ASCII函数相反。它根据NUMBER码返回字符
SELECT CHR(76) “字符代码” FROM DUAL;

SELECT CHR(108) “字符代码” FROM DUAL;

SELECT CHR(15113614) “字符代码” FROM DUAL;



SELECT DUMP(‘Li Hao’, 10) FROM DUAL;
10：十进制表示法

1010：字符集名称的十进制表示法
SELECT DUMP(‘Li Hao’, 1010) FROM DUAL;

SELECT DUMP(‘Li Hao’, 16) FROM DUAL;
16：十六进制表示法

SELECT DUMP(‘Li Hao’, 1016) FROM DUAL;
1016：字符集名称的十六进制表示法

SELECT DUMP(‘Li Hao’, 1017) FROM DUAL;
1017：具有字符集名称的单个字符