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

Can we join tables without foreign key?

909

---

What is the difference between python and sql?

940

---

what is oracle database ? : Sql dba

972

---

How to rename a column in the output of sql query?

1005

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2230

---

What information is needed to connect sql*plus an oracle server?

981

---

What is normalisation and its types?

957

---

What is a recursive stored procedure?

1098

---

What is range partitioning?

913

---

What is sharding in sql?

918

---

What are character functions?

1043

---

What's the difference between a primary key and a clustered index?

947

---

What is a sql instance vs database?

1038

---

What is the use of index in sql?

960

---

What is audit logout in sql profiler?

979

---