how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

Why do you partition data?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

what is 'mysqlcheck'? : Sql dba

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 to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

What are the uses of merge?

0 Answers  

---

What is serial sql?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

What is the difference between local variables and global variables?

0 Answers  

---

What are the types of operators available in sql?

0 Answers  

---