Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to split strings in pl/sql or in sql/plus
Hello Mr.Davis Sykes
cc: to wonderful reader and repliers
O! this is great, you are showing me how to do perl kind of stuf in
PL/SQL
Wonderful!!!, i will take your sample with your permission.
One last question
Does Oracle 10G is bundled (Machine level ) with perl?(Joke!!.
As oracle 10 G is added with Regular expression.)
Thnaks again
David Sykes のメッセージ:
> Here's some pl/sql code I used a few years ago:
>
> set serveroutput on;
>
> declare
>
> components owa_text.vc_arr ;
>
> string1 varchar2(200) default '06/13/2005';
>
> begin
>
> if (owa_pattern.match(string1, '(\w*)/(\w*)/(\w*)', components)) then
>
> for counter in 1 .. components.count loop
> dbms_output.put_line(components(counter));
> end loop;
>
>
> end if;
> end;
> /
>
>
>
>
> this works in 9i (9.2) here is the output:
>
>
> QL*Plus: Release 8.1.7.0.0 - Production on Thu Jun 9 15:47:58 2005
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.6.0 - Production
>
> 06
> 13
> 2005
>
> PL/SQL procedure successfully completed.
>
>
>
>
>
> Dave
>
>
> baka wrote:
>
> > hello
> > I want to break the the follwoing string variable into two strings.
> >
> > eg; str="abcd\wxyz"
> > into
> > str1="abcd"
> > str2="wxyz"
> >
> > i know how to do this in all 4GLs .
> > is it possible to do it in SQL/PLUS or PL/SQL?
> > (by the way i am re3ading a datfile from a .csv)
> >
> > Thanks in Advance
> >
Received on Fri Jun 10 2005 - 22:45:34 CDT