State the difference between implict and explict cursor's?

7 Answers   CTS,

---

What are the possible values that can be stored in a boolean data field?

0 Answers  

---

What is procedure function?

0 Answers  

---

What is a loop in sql?

0 Answers  

---

What is schema in sql example?

0 Answers  

---

---

What do you understand by pl/sql cursors?

0 Answers  

---

What is sql partition function?

0 Answers  

---

What are the two types of cursors in pl sql?

0 Answers  

---

How do you write a subquery?

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,

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

When should I use nosql database?

0 Answers  

---