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;

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

What is the need of a partition key?

0 Answers  

---

How do you select unique values in sql?

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

---

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---

What is crud sql?

0 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---