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
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is difference between stored function and application function?
Why do we use triggers?
List the ways to get the count of records in a table?
what is the command line end user interface - mysql? : Sql dba
How are sql commands classified?
what are the different type of sql's statements ? : Sql dba
Show how functions and procedures are called in a pl/sql block.
Is progress software supports to ( pl/sql )?
What's the difference between inner join and left join?
What is a nested table in word?
Is sql dba a good career? : SQL DBA
how many groups of data types? : Sql dba
What is sql in oracle?
How to find 3rd highest salary of an employee from the employee table in sql?