Explain mutating table error.

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

Explain lock escalation? : Transact sql

0 Answers  

---

How to add a column ‘salary’ to a table employee_details?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

Describe sql comments?

0 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

What is a pl/sql block?

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,

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---