Re: how to replace column data in Oracle

Try :
'update reports set report_code=2 where report_code=1'

Better :
 read a book on sql.

Ted

On Sat, 9 Dec 2000 14:35:52 +1100, "hawk" <hawk_at_hotmail.com> wrote:

>Hi all,
>
>I would like to know how to replace the value of a column in a table in
>Oracle. let's say we have a table called REPORTS and we have a column
>called REPORT_CODE and some of the entries in that column are 1. I want to
>change all those 1's to 2'. What is the syntax for that?
>
>thanks
>
>

EMail: knijff_at_bigfoot.com Received on Sat Dec 09 2000 - 06:44:55 CST