SQL> SELECT INITCAP ('helloworld') FROM dual ;
INITCAP('HELLOWORLD'
--------------------
Helloworld
LOWER 大写转小写
UPPER小写转大写
SQL> SELECT DISTINCT UPPER (' nEXt') FROM dual ;
UPPER('NEX
----------
NEXT
SQL> SELECT DISTINCT UPPER (' nEXt'),lower ('Hello') FROM dual ;
UPPER('NEX LOWER('HEL
---------- ----------
NEXT hello
SQL>
&inputname 输入字符
SQL> SELECT * FROM EMP where ENAME= UPPER('&inputname' ) ;
输入 inputname 的值: smith
原值 1: SELECT * FROM EMP where ENAME= UPPER('&inputname' )
新值 1: SELECT * FROM EMP where ENAME= UPPER('smith' )
EMPNO ENAME JOB MGR HIREDA
---------- -------------------- ------------------ ---------- ------
7369 SMITH CLERK 7902 17-12月
--------------------------------------------------------------------------------
SQL> SELECT INITCAP ('helloworld') FROM dual ; dual表示虚拟表的意思。initcap将首写字母转为大写子母
INITCAP('HELLOWORLD'
--------------------
Helloworld
--------------------------------------------------------------------------
SQL> SELECT ENAME FROM EMP WHERE LENGTH (ENAME) = ('&INPUTNAME') ;
输入 inputname 的值: 6
原值 1: SELECT ENAME FROM EMP WHERE LENGTH (ENAME) = ('&INPUTNAME')
新值 1: SELECT ENAME FROM EMP WHERE LENGTH (ENAME) = ('6')
ENAME
--------------------
MARTIN
TURNER
MILLER
LENGTH统计函数的使用,如上所述。为用户名为6个字符的雇员名字
--------------------------------
字符替换函数
语法:字符串 REPLACE (列 |字符串,要查找的内容,新的内容)
SQL> SELECT REPLACE(ename,UPPER ('s'),'_') FROM EMP ;
REPLACE(ENAME,UPPER(
--------------------
_MITH
ALLEN
WARD
JONE_
MARTIN
BLAKE
CLARK
_COTT
已选择14行。
SQL> SELECT REPLACE(ename,'_','S') FROM EMP ;
REPLACE(ENAME,'_','S
--------------------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
已选择14行。
SUBSTR使用,截取指定位置的字符串,如下所示
SQL> SELECT SUBSTR ('YAOHAOHAOXUEXI',10) FROM DUAL ; 从字符串开始以后的字符串,下标从1开始
XUEXI
SUBSTR('YA
----------
SQL> SELECT SUBSTR ('YAOHAOHAOXUEXI',10,3) FROM DUAL ; 从字符串位置及以后指定的几个字符串
SUBSTR
------
XUE