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
- 7237 Views
- I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
Buddy i have did this thru the D2k, while creating the
column with the datatype varchar2 and put the format of the
field on the form level as the time format. this will
convert the time in seconds and store in the database.for
ex ur 1:00 will store as 3600 in the database
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which are sql * plus commands?
What are conditional predicates?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
what are integrity rules?
What is the difference between between and in condition operators?
Are subqueries faster than joins?
What are inner outer left and right joins in sql?
What are its different types of dbms?
What is the process of copying data from table a to table b?
what is a materialized view? : Sql dba
What is the difference between sql and mysql?
how can we know the count/number of elements of an array? : Sql dba
What happens when a trigger is associated to a view?
What is sql injection vulnerability?
