using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

Are stored procedures faster than queries?

0 Answers  

---

What sql does db2 use?

0 Answers  

---

What is the maximum number of rows in sql table?

0 Answers  

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

Can pl sql procedure have a return statement?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

Explain correlated query work?

0 Answers  

---