Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What are the advantages of sql?

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

---

Write a query to find second highest salary of an employee.

27 Answers  

---

Explain constraints in sql?

0 Answers  

---

How do I send sql query results to excel?

0 Answers  

---

Explain the the delete statements in sql?

0 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

What are system versioned tables?

0 Answers  

---