What is a sql schema used for?

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---

State few characteristics of pl/sql?

0 Answers  

---

Is it possible to create startup or shutdown trigger for on-schema?

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,

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

What are inner and outer joins examples of both?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

Why do we use joins?

0 Answers  

---

What is the difference between joins?

0 Answers  

---