[跟着hsp步步学习系统]oracle培训学习集锦全360度扫描(2)

update emp set (job,sal)=(select job,sal from emp where name="smith") where name="scott"
to_char显示时间日期时用
to_date插入时用

转载于:https://www.cnblogs.com/jiangu66/archive/2013/04/02/2996584.html