Answer / pavani

No, we can't use more than one null value for unique key.
Unique means it doesn't accept duplicate values.

What is pl sql commands?

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

what is an associative array with example?

1 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

What are the advantages of indexing?

0 Answers  

---

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

What is the difference between row level and statement level trigger?

0 Answers  

---

What is materialized view in sql?

0 Answers  

---

what is single byte over head in oracle..?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---