Do we need to create index on primary key?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

how will you find out the last three records in a table with n no of records and delete them

3 Answers  

---

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

---

Can unique keys be null?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What is insert command in sql?

0 Answers  

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

what is bulk bind

4 Answers   TCS,

---