Answer Posted / s.syam sundar

oracle uses a private area to process and store data.this
private area is called as cursor

we have two types of cursors
they are implict and explict
implict cursor:- it is a cursor which controlled by oracle
itself
Ex: select statmets,insert,update and delete statmets

explict cursors:- it is a cursor which controlled by
programmer

controlling means
open cursor
fetch into
close cursor

Ex: cursor c1(cursor name) is select * from emp
where deptno =10;( this is in declarative section)


in excutable section:
open cursor c1;
fetch cursor c1 into some veriable or table name;
......
.....
close c1

we can use parameters in cursors

and we can not assiagn cursor name to a variable

and we need not use cursor statemets in for update cursor
because it will take care of

regards
S.syam sundar

How does a self join work?

1121

---

What is difference between stored procedure and trigger?

1166

---

What is pl sql in dbms?

949

---

what is a database lock ? : Sql dba

1169

---

What is rowid in sql?

984

---

define data blocks ? : Sql dba

990

---

Can we insert data in view?

962

---

Can we call dml statement in function?

1053

---

Why is theta join required?

1145

---

What is the difference between sum and count in sql?

986

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4280

---

Who is the owner of mysql database?

1057

---

what is data manipulation language? : Sql dba

1014

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1168

---

What are the advantages of stored procedure?

1003

---