oracle 字串操作，oracle字串

oracle 字串操作，oracle字串

select upper('testmyname') from dual;  --轉換為大寫

select lower('testmyname') from dual; --轉換為小寫

select upper(substr('testmyname'),5) from dual; --截取myname，並轉換為大寫

selec instr('testmyname','or') from dual; --尋找字元'or'，返回0

select tim('  hi  ) from dual; --返回hi

select rpad('smith',10,'月') as reft_star_smith,lpad('smith',10,'月') as ri
ght_star_smith from dual;          --左右倆側填充字元