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
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 |
Post New Answer View All Answers
what is blob? : Sql dba
What is the use of index in hive?
Is sql scripting language?
What are the types of join and explain each?
How does one load ebcdic data? : aql loader
How can the performance of a trigger be improved?
What is rename in sql?
Name the operator which is used in the query for pattern matching?
What is a rank in sql?
What is sql entity?
What is sql rowcount?
What are triggers in sql?
What is the difference between inner join and outer join?
Explain what is table in a database?
How can you tell the difference between an index and a view?