山东大学 数据库 实验四 复制表(6)

update test4_10

set sex=replace(sex,'性','')

update test4_10

set sex=replace(sex,' ','')

update test4_10

set age=2012-extract(year from birthday) where age is null

update test4_10

set class=replace(class,'级','') update test4_10

set class=replace(class,' ','')

update dbtest set test=4

select * from dbscore

三、 交实验

1． 交实验执行

update dbtest set test=4

2． 查结果执行

select * from dbscore