vlambda博客
学习文章列表

select concat(1,'a',2,'b') from dual //1a2b

select left('abcde',3) from dual //abc

select right('abcde',3) from dual //cde

select length('abcde') from dual //5

select date_format(curdate(),'%Y-%m-%d') from dual //2021-01-29 

cast(1.123 as decimal(5,4)) //1.1230

select instr('abcde','d') from dual //4

select substr('abc',2) from dual //bc

select substr('1.23456',instr('1.23456','.')+1) from dual //23456 

select reverse('abcde') from dual //edcba