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 blob? : Sql dba

1055

What is the use of index in hive?

958

Is sql scripting language?

973

What are the types of join and explain each?

986

How does one load ebcdic data? : aql loader

1093

How can the performance of a trigger be improved?

990

What is rename in sql?

915

Name the operator which is used in the query for pattern matching?

891

What is a rank in sql?

897

What is sql entity?

1029

What is sql rowcount?

948

What are triggers in sql?

971

What is the difference between inner join and outer join?

929

Explain what is table in a database?

1003

How can you tell the difference between an index and a view?

869