字符串的大小写操作
小写lower,大写upper,首字母大写initcap
19:16:38 SQL> select lower(ename),upper(ename),initcap(ename) from emp;
LOWER(ENAM UPPER(ENAM INITCAP(EN
---------- ---------- ----------
smith SMITH Smith
allen ALLEN Allen
ward WARD Ward
jones JONES Jones
martin MARTIN Martin
blake BLAKE Blake
clark CLARK Clark
king KING King
turner TURNER Turner
james JAMES James
ford FORD Ford
LOWER(ENAM UPPER(ENAM INITCAP(EN
---------- ---------- ----------
miller MILLER Miller
已选择12行。
已用时间: 00: 00: 00.04
19:17:16 SQL>
其它字符串操作函数
19:17:16 SQL> select ename,job,concat(ename,job) from emp;
ENAME JOB CONCAT(ENAME,JOB)
---------- --------- -------------------
SMITH CLERK SMITHCLERK
ALLEN SALESMAN ALLENSALESMAN
WARD SALESMAN WARDSALESMAN
JONES MANAGER JONESMANAGER
MARTIN SALESMAN MARTINSALESMAN
BLAKE MANAGER BLAKEMANAGER
CLARK MANAGER CLARKMANAGER
KING PRESIDENT KINGPRESIDENT
TURNER SALESMAN TURNERSALESMAN
JAMES CLERK JAMESCLERK
FORD ANALYST FORDANALYST
ENAME JOB CONCAT(ENAME,JOB)
---------- --------- -------------------
MILLER CLERK MILLERCLERK
已选择12行。
已用时间: 00: 00: 00.03
将两个字符连接到一起
下面三句话是求字符串的长度,字符串要单引。
select length('张三') from dual;--按照字
select lengthb('张三') from dual;--按字节
select lengthc('张三') from dual;--unicode 的长度
19:58:19 SQL> select length('张三') from dual;
LENGTH('张三')
--------------
2
已用时间: 00: 00: 00.00
19:58:55 SQL> select lengthb('张三') from dual;
LENGTHB('张三')
---------------
4
已用时间: 00: 00: 00.01
19:59:31 SQL> select lengthc('张三') from dual;
LENGTHC('张三')
---------------
2
已用时间: 00: 00: 00.01
20:00:03 SQL>
小写lower,大写upper,首字母大写initcap
19:16:38 SQL> select lower(ename),upper(ename),initcap(ename) from emp;
LOWER(ENAM UPPER(ENAM INITCAP(EN
---------- ---------- ----------
smith SMITH Smith
allen ALLEN Allen
ward WARD Ward
jones JONES Jones
martin MARTIN Martin
blake BLAKE Blake
clark CLARK Clark
king KING King
turner TURNER Turner
james JAMES James
ford FORD Ford
LOWER(ENAM UPPER(ENAM INITCAP(EN
---------- ---------- ----------
miller MILLER Miller
已选择12行。
已用时间: 00: 00: 00.04
19:17:16 SQL>
其它字符串操作函数
19:17:16 SQL> select ename,job,concat(ename,job) from emp;
ENAME JOB CONCAT(ENAME,JOB)
---------- --------- -------------------
SMITH CLERK SMITHCLERK
ALLEN SALESMAN ALLENSALESMAN
WARD SALESMAN WARDSALESMAN
JONES MANAGER JONESMANAGER
MARTIN SALESMAN MARTINSALESMAN
BLAKE MANAGER BLAKEMANAGER
CLARK MANAGER CLARKMANAGER
KING PRESIDENT KINGPRESIDENT
TURNER SALESMAN TURNERSALESMAN
JAMES CLERK JAMESCLERK
FORD ANALYST FORDANALYST
ENAME JOB CONCAT(ENAME,JOB)
---------- --------- -------------------
MILLER CLERK MILLERCLERK
已选择12行。
已用时间: 00: 00: 00.03
将两个字符连接到一起
下面三句话是求字符串的长度,字符串要单引。
select length('张三') from dual;--按照字
select lengthb('张三') from dual;--按字节
select lengthc('张三') from dual;--unicode 的长度
19:58:19 SQL> select length('张三') from dual;
LENGTH('张三')
--------------
2
已用时间: 00: 00: 00.00
19:58:55 SQL> select lengthb('张三') from dual;
LENGTHB('张三')
---------------
4
已用时间: 00: 00: 00.01
19:59:31 SQL> select lengthc('张三') from dual;
LENGTHC('张三')
---------------
2
已用时间: 00: 00: 00.01
20:00:03 SQL>