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 are sql injection vulnerabilities?

1024

What is parameter substitution in sql?

1079

What is the order of sql select?

1085

What is a null value?

1186

What do you mean by dbms? What are its different types?

1060

How to write a query to show the details of a student from students table whose

1059

Mention what is the plv (pl/vision) package offers?

1163

what are the type of locks ? : Sql dba

1006

What is pl sql and why it is used for?

1154

What is the difference between delete and truncate commands?

1097

What is the default isolation level in sql server? : Transact sql

1080

Why do we create views in sql?

1217

what is the use of set statement in tsql? : Transact sql

1059

What are stored procedures in mysql?

1069

How is indexing done in search engines?

1021