Answer / avi007

Statement level trigger is default.

Answer / vaibhavi_dixit

I think ,Default triggers in oracle are nothing but
Constraints.Constraints are the triggers which are executed
automatically at the time of DML operations.

Thanks
VD

Answer / ahmed

By default, a trigger is created in the enabled state.

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

What is a pdo connection?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

how to create user in sql and how to set password for that?

3 Answers  

---

---

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

What is the difference between function and procedure in pl/sql?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

Can we perform dml on view?

0 Answers  

---

What are hotfixes and patches?

0 Answers  

---