Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

Can we use joins in subquery?

0 Answers  

---

what is data integrity? : Sql dba

0 Answers  

---

How many triggers can be applied to a table?

0 Answers  

---

Mention what pl/sql package consists of?

0 Answers  

---

How to write pl sql program in mysql command prompt?

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,

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---