#alter table natoper,chave_u,c(23) #alter table conpgt,chave_u,c(23) #alter table repres,chave_u,c(23) #alter table moedas,chave_u,c(23) #alter table cartoes,chave_u,c(23) #alter table clipro,chave_u,c(23) #alter table engpro,chave_u,c(23) #alter table placta,chave_u,c(23) #alter table plapop,chave_u,c(23) #alter table plapxc,chave_u,c(23) #alter table tpfin,chave_u,c(23) #alter table unidad,chave_u,c(23) #alter table fornec,chave_u,c(23) #alter table cnvcad,chave_u,c(23) #alter table tpmov,chave_u,c(23) #alter table grupo,chave_u,c(23) #alter table sabor,chave_u,c(23) #alter table cidade,chave_u,c(23) #alter table epabarra,chave_u,c(23) #alter table clichave,chave_u,c(23) #alter table unidadc,chave_u,c(23) #UPDATE natoper SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE conpgt SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE repres SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE moedas SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE cartoes SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE clipro SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE engpro SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE placta SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE plapop SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE plapxc SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE tpfin SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE unidad SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE fornec SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE cnvcad SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE tpmov SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE grupo SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE sabor SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE cidade SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE epabarra SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE clichave SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23 #UPDATE unidadc SET chave_u='sagestru'||current_time::char(5)||to_char(current_date,'DD/MM/YY')||'00' WHERE LENGTH(TRIM(COALESCE(chave_u,'')))<23