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: create cursor c1(cursor name) as 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

Explain the the update statement in sql?

1036

---

what's the difference between a primary key and a unique key? : Sql dba

1050

---

What is varchar data type in sql?

1083

---

how to see the create table statement of an existing table? : Sql dba

1016

---

How do I view a sql trace file?

1027

---

Is big data nosql?

944

---

which operator is used in query for pattern matching? : Sql dba

1005

---

Is sql sequential or random?

1034

---

Is primary key a clustered index?

968

---

Explain the working of foreign key?

1067

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

960

---

Is trigger a stored procedure?

933

---

What is difference between my sql and sql?

1072

---

What is the difference between having and a where in sql?

1108

---

how many values can the set function of mysql take? : Sql dba

987

---