oracle如何通过两个表关联,修改其中一表中某列的数据
update A set A.E=B.H where A.G in(select B.G from B);
FOR UPDATE 可查询更改;
统计重复的记录:
TO_CHAR(TO_DATE(F_RZSJ,'yyyyMMdd')+90,'yyyyMMdd')
长度 length()应用:
select * from U
where f_sxrq is not null and length(f_sxrq)<>8
or f_rzsj is not null and length(f_rzsj)<>8
or f_htqdsj is not null and length(f_htqdsj)<>8
for update;
TO_CHAR \TO_DATE影响速度:
TO_CHAR(TO_DATE(F_RZSJ,'yyyyMMdd')+90,'yyyyMMdd')
between and 直接varchar计算;
内部子查询用外部的表