Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Converting delimited string into table columns

460798Nov 12 2010 — edited Nov 12 2010
The source system will send delimited string to my procedure. I need to convert them into table columns to process.
For example
the data for sply_reord_no and order_qty will come as '002R456,100|003Y678,200|093T88,10'

I need to convert this into
sply_reord_no          ord_qty      
-------------------    ------------    
002R456                 100
003Y678                 200
093T88U                 10
Dear Experts
Please help.
Thanks in advance

Edited by: Saaya on Nov 12, 2010 10:47 AM

Comments

843811
accum: includes the time for the entries that appear above this one in the list. The last entry will have an accum of 100%
843811
You can also use perfanal utility provided in java.sun.com. It is very useful in interpreting the results of hprof.

~Rajesh.B
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 10 2010
Added on Nov 12 2010
7 comments
3,074 views