Answer / gogu s k

For security and audit related events and to record changes
done to database, triggers are best.

For applying business rules and performing dml operations
procedures are ideal.

Is sql a programming?

0 Answers  

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

What is an implicit commit?

0 Answers  

---

How can you fetch common records from two tables?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

Why is %isopen always false for an implicit cursor?

0 Answers  

---

How is sql used in oracle?

0 Answers  

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

what is sql? : Sql dba

0 Answers  

---

Is a table valued function object?

0 Answers  

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---