--效果一样
update(select*fromgongysbwhereid='986771048')setquanc='山西东庄煤业有限公司1111';
update gongysb set quanc = '山西东庄煤业有限公司' where id='986771048' ;
delete from (select id from gongysml where to_char (tjsj, 'yyyy-MM') = '2015-12');
select id from gongysml where to_char( tjsj,'yyyy-MM' ) = '2015-12'
orcale update delete 两种写法
最新推荐文章于 2024-01-09 13:00:00 发布