what is a composite primary key ? : Sql dba

0 Answers  

---

what is called after appearing where clause

3 Answers  

---

what is commit? : Sql dba

0 Answers  

---

What is java sql package?

0 Answers  

---

what is normalization? : Sql dba

0 Answers  

---

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,

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

Can we write ddl statements in functions?

0 Answers  

---

What if we write return in procedure?

0 Answers  

---

How is a PL/SQL code compiled?

0 Answers  

---

Can we rollback after truncate?

0 Answers  

---