Answer / Shailendra Kumar Rajpoot

The BASE_OBJECT_TYPE column in the USER_TRIGGERS data dictionary view indicates the type of object that the trigger is associated with. It can have one of the following values:n
1. TABLE - Trigger on a table.
2. VIEW - Trigger on a view.
3. PROCEDURE - Trigger on a procedure.
4. PACKAGE - Trigger on a package.

What is the difference between local and global temporary table?

1 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

1 Answers  

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

What is a unique constraint?

1 Answers  

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

How do I add a database to sql?

1 Answers  

---

Is sql between inclusive?

1 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

1 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

How do I quit sql?

1 Answers  

---

what is text? : Sql dba

1 Answers  

---

What is the difference between a primary key and a unique key?

1 Answers  

---