Explain the order of sql statement execution?

0 Answers  

---

What are keys in sql?

0 Answers  

---

What is the difference between union and union all command?

0 Answers  

---

what is foreign key? : Sql dba

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,

---

What are different types of sql commands?

0 Answers  

---

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

Does oracle use sql?

0 Answers  

---

What is the difference between subquery and correlated query?

0 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

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,

---

How to process query result in pl/sql?

0 Answers  

---