Oracle数据库字符串操作
select lower('Hello'),upper('Hello') from dual;
select * from emp where ename='&inputname';
select * from emp where ename=UPPER('&inputname');
select initcap('helloWorld') from dual;
select initcap(ename) from emp;
select ename,LENGTH(ename) from emp;
select * from emp where length(ename)=5;
select REPLACE(enames,UPPER('a'),'_') from emp;
select replace('hello world nihao zaijian',' ','') from dual;
select SUBSTR('helloworldnihao',11) from dual;
select SUBSTR('helloworldnihao',6,5) from dual
select SUBSTR ('helloworldnihao',1,5) from dual;
select ename,SUBSTR(ename,1,3) from emp;