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

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