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 do you mean by rowid?

0 Answers  

---

How many types of relationship are there?

0 Answers  

---

What is the difference between stored procedure and view?

0 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

Which software is used for pl sql programming?

0 Answers  

---

What are different types of refreshment techniques of materialised view

2 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

How many parts of a pl sql block are optional?

0 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

What are the sql aggregate functions?

0 Answers  

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---