Home » SQL & PL/SQL » SQL & PL/SQL » Splitting multiple values in a column separated by tab
Splitting multiple values in a column separated by tab [message #38416] Wed, 17 April 2002 05:27 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I have a column that is varchar2(255) that contains a number of values separated by tab. I want to know if it is possible to split these values and insert them into a separate table? I know pl/sql doesn't have a split function, but maybe with the combination of decode/instr?? Any assistance is greatly appreciated.

Joe

Report message to a moderator

Re: Splitting multiple values in a column separated by tab [message #38418 is a reply to message #38416] Wed, 17 April 2002 05:48 Go to previous message
Epe
Messages: 99
Registered: March 2002
Member
Hello Joe,

I answered this question in the SQL-Forum.

--> there is a split function !! SUBSTR()

Enjoy,

epe

Report message to a moderator

Previous Topic: splitting multiple values in a column
Next Topic: & Literal String in PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 19:12:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.