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,

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

What are transaction and its controls?

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

How to order siblings in oracle hierarchy queries?

0 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

Which is faster truncate or drop?

0 Answers  

---

What is mdb stand for?

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

What is where clause in sql?

0 Answers  

---