Re: PL/SQL string parsing question

if it's not homework, then one could suggest you to perhaps make it be your homework!

Sybrand has already explained how.

Regards

"Xiaobin Guan" <xiaguan_at_nhgri.nih.gov> wrote in message news:wnok8.36$f5.303224_at_mencken.net.nih.gov...
> This is not for a HOMEWORK.
> Is there a rule that some questions should be answered whereas others
should
> not?
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:fg349ukf8hkr12k0hq2n9hfg2g0t3oi83r_at_4ax.com...
> > On Fri, 15 Mar 2002 09:19:07 -0500, "Xiaobin Guan"
> > <xiaguan_at_nhgri.nih.gov> wrote:
> >
> > >Hello,
> > >
> > >Here is what I need to do:
> > >I have a varchar2 column, or maybe clob, saying it contains 500
> characters
> > >(all letters, with no space in between). Then I need to take some
> characters
> > >out by order numbers, saying I don't need number 23 to 49, 148-169. Now
I
> > >have three pieces left. The first one is from 1-22 (22 characters), The
> > >second one is from 50-147, and the third one is from 170 - 500. The
last
> > >thing I need to do is compare these pieces and pick up the longest one.
> > >
> > >Any idea how can I do these in PL/SQL?
> > >
> > >Thanks a lot,
> > >Xiaobin
> > >
> >
> >
> > This question has the word HOMEWORK written all over it.
> > Please refer to the substr and length functions and try to resolve it
> > yourself. You will learn from it.
> >
> > Regards
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Fri Mar 15 2002 - 09:37:07 CST