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:23:28 CST
