第三章 组函数
字符串函数
-- concat 连接两个字符串
select concat('abc','ABC') from dual;
select 'abc'||'ABC' from dual;
select concat(first_name,'_')||last_name con,t.* from EMPLOYEES t;
-- initcap 返回字符串,第一个大写,其余小写
select initcap(email) from EMPLOYEES;
-- length 返回字符串长度
select length(email),t.* from EMPLOYEES t;
-- lower 所有字符小写
-- upper 所有字符大写
select lower(first_name),upper(last_name),t.* from EMPLOYEES t;
-- substr 字符串截取
select substr('123456789',3,4) from dual;