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

2 Answers   JDA,

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

What does closing a cursor do?

0 Answers  

---

Which join is like an inner join?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What sql does db2 use?

0 Answers  

---

What is the use of double ampersand (&&) in sql queries? Give an example

0 Answers  

---

How delete a row in 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  

---