What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---

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  

---

Is time a data type in sql?

0 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

Write an sql query to select all records from the table?

0 Answers  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

What is a primary key? Explain

0 Answers  

---

Can you join views in sql?

0 Answers  

---