从默认表EMP里面调取各种数据
SELECT * FROM EMP
select '['||trim(ename)||']' from emp;
select * from EMP where trim(ename) = 'SMITH';
SELECT * FROM emp
--Instr 第二个字符串出现位置的索引
select Instr('Hello World','or') a from dual
select * from dual
--Substr 字符串处理,1表示起始索引位置,2表示获取字符串的长度
select substr('abc',1,2) from dual
--Lpad 10表示获取的字符串长度,*表示左侧添加的字符(重复添加至需要长度)
select Lpad('abc',10,'*') from dual
--Rpad
select Rpad('abc',10,'*') from dual
--replace 替换字符
Select replace(ename,'A','a') from emp
--Round 四舍五入
select round(477,-2) from dual
select round(412.313,-2) from dual
--Mod 取余
select mod(11,8) from dual
--TRUNC 截断
select TRUNC(49.66666,0) from dual
----日期使用
--sysdate 获取本机时间
select sysdate from dual
--MONTHS_BETWEEN
select * from emp
select * from emp order by hiredate desc
select hiredate from emp where months_between ('198