APEX

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!

Substring Function

953160Aug 20 2012 — edited Aug 21 2012

Hi , Every one I'm new here and APEX

but i have some question and hope you guy can help me ..

i have string like this(store in Item)

  1:100000,2:150000,3:200000,4:250000,5:100000,

it define ID:VALUE , ID:VALUE,...
how can i substring it? like this

1:100000
2:150000
....

and then i must substring it again for ID and VALUE How can i do that?

finally i will update table by ID and Value that substring already How Can i do that? create function or process .. and how?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2012

Added on Aug 20 2012

#apex-discussions

6 comments

332 views