What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What is trigger price?

0 Answers  

---

What is the difference between unique and primary key constraints?

0 Answers  

---

Where do we use pl sql?

0 Answers  

---

---

what is a cursor? : Sql dba

0 Answers  

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---

What is CYCLE/NO CYCLE in a Sequence?

2 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,

---

What are inbuilt functions in sql?

0 Answers  

---

What is meaning of <> in sql?

0 Answers  

---

How can you create an empty table from an existing table?

0 Answers  

---