oracle 的 update 语句实例

 UPDATE imp_e  a SET a.B3=(SELECT b.b2 FROM imp_d b WHERE b.B1=a.b1) WHERE EXISTS (SELECT 1 FROM imp_d b WHERE b.b1=a.b1)

UPDATE imp_e a SET a.B4=(SELECT b.b2 FROM imp_c b WHERE b.b2=a.b2) WHERE EXISTS (SELECT 1 FROM imp_c b WHERE b.b2=a.b2)

 

UPDATE TBL_CA_COLUMN_DATA SET creator = REPLACE(creator,'.0','') WHERE id LIKE 'yd20090309%'

UPDATE TBL_CA_COLUMN_DATA SET creator =  REPLACE(creator,'','') WHERE id LIKE 'yd20090309%' AND LENGTH(creator)=6

UPDATE TBL_CA_COLUMN_DATA SET creator =CONCAT('0',creator) WHERE id LIKE 'yd20090309%' AND LENGTH(creator)=6