Re: Replace in table

From: Harald Maier <maierh_at_myself.com>
Date: Tue, 26 Aug 2003 12:45:49 +0200
Message-ID: <m34r04ofxe.fsf@ate.maierh>

djockheck_at_gauselmann.de (Detlef Jockheck) writes:

> 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

replace( col, 'a', 'abc' ). see too the sql reference manual.

Harald Received on Tue Aug 26 2003 - 05:45:49 CDT

This message: [ Message body ]
Next message: Christian: "ora-01722 invalid number"
Previous message: Detlef Jockheck: "Replace in table"
In reply to: Detlef Jockheck: "Replace in table"
Next in thread: andrewst: "Re: Replace in table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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