Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Replace in table

Replace in table

From: Detlef Jockheck <djockheck_at_gauselmann.de>
Date: 26 Aug 2003 03:39:18 -0700
Message-ID: <cd0f0f92.0308260239.62e2641c@posting.google.com>


Hi,

how can I replace "a" with "abc" in a column? I would prefer a sql-solution.

eg:
column_old
a
hda
jkaj

column_new
abc
hdabc
jkabcj

ciao
Detlef Received on Tue Aug 26 2003 - 05:39:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US