How many sql databases can you have on one server?

0 Answers  

---

Which join is default?

0 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

---

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 is sql query optimization?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

How will you distinguish a global variable with a local variable in pl/sql?

0 Answers  

---

Does db2 use sql?

0 Answers  

---

Does sql use python?

0 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

Which command is used to delete a package?

0 Answers  

---