Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

Which is faster truncate or drop?

0 Answers  

---

What is the best partition size for windows 10?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers  

---

What does (+) mean in sql joins?

0 Answers  

---

How do I view a table in sql?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

explain access control lists. : Sql dba

0 Answers  

---

What is not equal in sql?

0 Answers  

---

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

---

Does truncate remove indexes?

0 Answers  

---