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;

Why do we use joins in sql?

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---

What is ON DELETE CASCADE?

3 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

define sql

3 Answers   Zensar,

---

Can we call procedure in select statement?

0 Answers  

---

What is dense_rank?

0 Answers  

---

Is id a reserved word in sql?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---