Home -> Usenet -> comp.databases.oracle -> Changing Specific Words with the UPDATE statement

Changing Specific Words with the UPDATE statement

From: Hassan Ayub <hassan_ayub_at_yahoo.com>
Date: 8 Nov 2001 07:54:10 -0800
Message-ID: <1df2b71.0111080754.731d5e69_at_posting.google.com> 






Hi there,


    Is there any possibility that one can use the UPDATE statement in
such a manner that only one specific word is changed in a column/field
and the rest of the words/characters in the column/field remains the
same. For example:
     


  Cylinders Empty for Nitrogen Gas



  Now I want to change Cylinders to Cylinder and the rest of the
statement should remain the same, but whenever I run the UPDATE
statement it changes the whole statement to Cylinder only. Do I need
write a procedure or something for this purpose?



 Thanks in advance



Hassan
Received on Thu Nov 08 2001 - 16:54:10 CET












Original text of this message