What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

---

---

Give the structure of the function ?

2 Answers  

---

When is a declare statement required?

0 Answers  

---

What are user defined functions?

0 Answers  

---

Is nosql faster than sql?

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---