Re: Generic Oracle SQL question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 09 Feb 2004 20:40:12 +0100
Message-ID: <lfof20lkcdhmcmism4ffohcp3qbq8n9vcd@4ax.com>

On 9 Feb 2004 10:48:38 -0800, jack_posemsky_at_yahoo.com (Jack) wrote:

>Greetings, wondering if anyone can tell me how to parse out these
>subfields from an existing field ?
>
>FIELD_1 Data:
>
>James.ferrin.gilroy.456
>Kay.kit.newjersey.69796321
>
>Thank you !
>
>Jack

Please look up the substr and instr functions in the documentation and don't ask this forum to do your homework.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Feb 09 2004 - 13:40:12 CST

Re: Generic Oracle SQL question - parsing