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!

Stupid Column

460609Mar 24 2006 — edited Mar 25 2006
Hey All,
I am having a table which has column SCBP of varchar2 data type as follow.

SCBP
+800
+800+3000
+800+3000+2975
+800+3000+2975+5000
+1600
+1600+2850

The problem is that i have to find the sum of that string eg for second row which is string +800+3000 i want value as 3800 which is addition of 800 and 3000. Similarly for string +800+3000+2975 value should be 6775 which is addition of 800, 3000 and 2975
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2006
Added on Mar 24 2006
23 comments
1,614 views