What is range partitioning?

0 Answers  

---

what are the 'mysql' command line options? : Sql dba

0 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

How to find last day of the month in sql query

4 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

what are the properties and different types of sub-queries? : Sql dba

0 Answers  

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

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 a clob in sql?

0 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---