Update to clear entire column

Question

Navigation

#1 by (4 votes)
#2 by (1 votes)

1

I need to make a update in the bank where I clear 30,000 records, however I need to zero only the record of one of the columns.

Example table: cd_product | ds_product | pr_product | dt_update

This table contains the 30mil records and I need to clear all dt_atualizacao , but only it, the other columns can not be changed.

How can I mount this update ?

sql oracle pl-sql

asked by anonymous 06.01.2015 / 12:30

2 answers

1

UPDATE TABELA SET DT_ATUALIZACAO = NULL

But be warned:

1) Are there triggers in this table, does update generate any demand for this operation? Log etc

2) Is there room for the bank's audit track?

Doubt "frightens" as it is a trivial operation as @Maniero said and may mask some other problem.

06.01.2015 / 13:22

score 4 · Accepted Answer

It would be very trivial to override if it is possible and desirable:

UPDATE tabela SET dt_atualizacao = null;

Or put a low value:

UPDATE tabela SET dt_atualizacao = TO_DATE('0000-01-01 00:00:00', 'yyyy/mm/dd hh24:mi:ss');