Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7906 Views
- I also Faced
- E-Mail Answers
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 the difference between jpql and sql?
Which software is used for pl sql programming?
How does one load ebcdic data? : aql loader
what is the difference between a local and a global temporary table? : Sql dba
How does one use sql*loader to load images, sound clips and documents? : aql loader
Define join and name different types of joins?
How can you save or place your msg in a table?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Do we need to rebuild index after truncate?
What is the need of a partition key?
What is the difference between inner join and left join?
What can you do with pl sql?
what are all the common sql function? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Is sql free?
