Answer / 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

Answer / 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

Answer / avi007

select sum(hiredate,'hh') ||':'|| sum(hiredate,'mm')
||':'|| sum(hiredate,'ss') from emp;

what is auto increment? : Sql dba

0 Answers  

---

What is the basic structure of PL/SQL ?

6 Answers  

---

What is the difference between inner join and left join?

0 Answers  

---

Can you selectively load only those records that you need? : aql loader

0 Answers  

---

What is faster join or subquery?

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

what is sub-query? : Transact sql

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

How can I change database name in sql?

0 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---