Re: PL SQL

From: cf <news_at_sitinfo.com>
Date: Wed, 19 Dec 2001 10:46:46 +0100
Message-ID: <3c206207$0$24010$4d4eb98e@read.news.fr.uu.net>

Use function instr :
Ex:

    select instr('123,455,744,855,886,96,14523,4578,25',',',1,1) from dual     -> 4
    select instr('123,455,744,855,886,96,14523,4578,25',',',1,8) from dual     -> 34
    select instr('123,455,744,855,886,96,14523,4578,25',',',1,9) from dual     -> 0

Christophe.

"s Lehaire" <s.lehaire_at_meilleuregestion.com> a écrit dans le message news: 9vplfs$12i$1_at_reader1.imaginet.fr...
> Hi,
> (I'm french guy so excuse for my english)
>
> I've got a little problem with my procedure
> I receive one string : number seprated by comas
> I need to update my table with those number but I don't know how many
number
> I have.
> so can you explain me how to do?
>
>
Received on Wed Dec 19 2001 - 03:46:46 CST