Why use truncate instead of delete?

0 Answers  

---

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

---

How do I make my sql query run faster?

0 Answers  

---

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

What is the use of nvl function?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

what is self join and why is it required? : Sql dba

1 Answers  

---

why not null constraint showing its constraint type as 'c'

1 Answers  

---

What is bitemporal narrowing?

0 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---