Re: Is it possible to globally change a value in every column without doing an update on each one

There is no single UPDATE command that will do this. The format of the update command is:

   UPDATE table
   SET column = value
   WHERE condition

By the syntax of the command, you can see that this is not possible. You will either have to issue the multiple update commands, or use SQL*Plus to format the output of the column (if that suits your needs)

HTH,
Brian

tony wrote:
>
> we have a table with 75 columns, a value of 999.9999 needs to be changed to
> 999.9 regardless of where it appears. Do we need to do an update on every
> single column or is it possible for one update column satement to do it?
Received on Thu Sep 09 1999 - 15:23:50 CDT