Re: Newbie needs help

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sat, 14 Jul 2001 21:02:56 +0100
Message-ID: <9iq8de$kkg$1@uranium.btinternet.com>

If the question is: how do I insert a text into an existing string then the answer would go something like this (inserts a new text fragment at position 10):

update my_table
set my_column = substr(my_column,1,10) || 'new text' || substr(my_column,11,length(my_column);

Hope this helps,

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"Sven Gomber" <sgomber_at_adlink.net> wrote in message
news:3B4ED5F2.3190E7FB_at_adlink.net...


> Hi all,

> i'm very new into Oracle 8i and i need to replace a string for a

> specific table - the problem is the utilization of wild cards within

> this function:

> i'm trying to replace something like :    select replace('http://1%',

> 'http://1%', 'http://a1168') "url" from sites

> from my 'old' sql-knowledge i would use the substr-function but i need

> some explanation on it ...

>

>

> thanks a lot

>

> Sven

>

Received on Sat Jul 14 2001 - 15:02:56 CDT