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 properties of a transaction? : Sql dba

1139

What is the difference between local and global temporary table?

1089

Why do we go for stored procedures?

1127

What is a composite primary key?

1142

Differentiate between syntax and runtime errors.

1242

Can you join views in sql?

996

What is data modelling in sql?

1077

How to rename a table?

1076

What is recursive stored procedure?

1142

What is data profiling in sql?

1139

Why commit is not used in triggers?

1091

How can we store rows in PL/SQL using array?

1270

What is nosql db?

1020

What is normalization in a database?

1198

What is the difference between functions, procedures, and packages in pl/sql?

1096