Answer / shwetha k

A cursor is a pointer to pointing to this memory area and used to retrieve data row by row instead of all row at a time.
select statement fetches only one row.so to overcome this problem cursor is used to hold the set of rows or data in one variable and can do whatever manipulation we want to do.

How do I view a sql database?

0 Answers  

---

what are Dynamic SQL statements?

9 Answers  

---

How many sql statements are used?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

---

Is drop table faster than truncate?

0 Answers  

---

Explain some predefined exceptions.

0 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What are types of joins?

0 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

What is count * in sql?

0 Answers  

---

Who developed sql?

0 Answers  

---