立即学习:https://edu.csdn.net/course/play/27328/363961?utm_source=blogtoedu
select length('xuyan') from dual;
dual 虚拟表 可省略
case sex
when '男' then 'F'
when '女' then 'M'
else ''
end as sex
立即学习:https://edu.csdn.net/course/play/27328/363961?utm_source=blogtoedu
select length('xuyan') from dual;
dual 虚拟表 可省略
case sex
when '男' then 'F'
when '女' then 'M'
else ''
end as sex