Skip to Main Content

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!

how to take second row to be minus the first row

prooraJun 2 2014 — edited Jun 9 2014

Dear ,

assume my table like this stock name and times

STOCKHeader 2Header 3
A2031:302:00
A2032:403:00
A2033:024:00
A2035:006:00

the output shout be like the below

STOCK123
A20300:4000:0201:00

1 column is

2:40 - 2:00

2 column is

3:02 - 3:00

3 column is

05:00 - 04:00

Regards,

This post has been answered by Frank Kulash on Jun 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2014
Added on Jun 2 2014
3 comments
2,779 views