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

Can triggers stop a dml statement from executing on a table?

1067

---

what is bdb (berkeleydb)? : Sql dba

1010

---

Is sql pronounced sequel or sql?

1247

---

What is exception? What are the types of exceptions?

1060

---

How would you convert date into julian date format?

989

---

What is trigger and stored procedure in sql?

1017

---

what are all types of user defined functions? : Sql dba

1030

---

How do you update f as m and m as f from the below table testtable?

1834

---

Are stored procedures faster than queries?

929

---

When can we use the where clause and the having clause?

1010

---

Can we create clustered index without primary key?

948

---

what is uncommittable transactions? : Transact sql

987

---

Why is a trigger used?

926

---

List and explain the different types of join clauses supported in ansi-standard sql?

1345

---

What is the need of a partition key?

972

---