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,

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

Which is better cte or subquery?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

What is acid property in a database?

0 Answers  

---

What is the use of sqlerrd 3?

0 Answers  

---

How do I remove all records from a table?

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

What are stored procedures in mysql?

0 Answers  

---

What is integrity in sql?

0 Answers  

---