OraFAQ Forum: SQL & PL/SQL » Parsing comma separated String

Home » SQL & PL/SQL » SQL & PL/SQL » Parsing comma separated String

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Parsing comma separated String [message #10812]

Wed, 18 February 2004 09:17

Scion78
Messages: 15
Registered: February 2004

Junior Member

v_str := '62.3454,32.4565';
I want to split it at the ','
Any suggestions would be helpful

Report message to a moderator

Re: Parsing comma separated String [message #10819 is a reply to message #10812]

Wed, 18 February 2004 11:39

sverch
Messages: 582
Registered: December 2000

Senior Member

SQL> declare
2
3 v_str varchar2(40):= '62.3454,32.4565';
4
5
6 begin
7
8 v_str:= REPLACE(v_str,'.',',');
9
10 DBMS_OUTPUT.PUT_LINE (V_STR);
11
12 END;
13 /

PL/SQL procedure successfully completed.

SQL> SET SERVEROUTPUT ON
SQL> /
62,3454,32,4565

PL/SQL procedure successfully completed.

Report message to a moderator

Re: Parsing comma separated String [message #10870 is a reply to message #10812]

Sat, 21 February 2004 05:32

Sudhakar
Messages: 34
Registered: May 2002

Member

Hi,

select
substr('62.3454,32.4565',0,instr ('62.3454,32.4565',',')-1),
substr('62.3454,32.4565',instr ('62.3454,32.4565',',')+1) from dual

regards,
Sudhakar

Report message to a moderator

Previous Topic:	Show details of employee hiredates and the date of their first payday.
Next Topic:	Last Rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 01:59:13 CDT 2024