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,

---

how to use case expression? : Sql dba

0 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

What are dml commands?

0 Answers  

---

What are the syntax and use of the coalesce function?

0 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What are sql constraints?

0 Answers  

---

Is it possible to sort a column using a column alias?

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

Is pl sql still used?

0 Answers  

---

What is cursor status?

0 Answers  

---