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.

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---

Are subqueries faster than joins?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is linq to sql?

0 Answers  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---

How does an execution block start and end in pl sql?

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

What will happen after commit statement ?

2 Answers  

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

What is full join in sql?

0 Answers  

---