select sum(to_number(substr(num,1,2))) ||':'|| su

how to insert values like 10:10:00,30:25:00 etc.into table
after insert how can i sum the above insert values to get
the result as 40:35:00

Question Posted / sushant kumar

Answer Posted / sushant kumar

select sum(to_number(substr(num,1,2))) ||':'||
sum(to_number(substr(num,4,2))) ||':'||
sum(to_number(substr(num,7,2)))
from tt

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is data manipulation language?

1174

How do I find duplicates in the same column?

1059

Explain the select statement in sql?

1095

Who developed sql?

1019

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1036

What is a temporal data type?

1027

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

987

What will you get by the cursor attribute sql%notfound?

1041

What is the non-clustered index in sql?

1050

What is sql and its types?

1157

What is the difference between left join and right join?

930

How do we accept inputs from user during runtime?

1043

what is the difference between primary key and unique key? : Sql dba

1015

How to install oracle sql developer?

1021

Is sql pronounced sequel or sql?

1247