Answer Posted / raam
Cursor is a private memory area. to perform transations on
morethan one row we are using cursors. required multi-
records will be fetched to cursor area and will do
operations on those records. It is a temperary memory area.
Winthout Cursor pl/sql can perform only one record at a
time.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is full join?
Is primary key an index?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the difference between numeric and autonumber?
How is debugging done?
Can we use rowid as primary key?
How does one load ebcdic data? : aql loader
Is oracle sql free?
What are the features of pl sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What steps server process has to take to execute an update statement?
How do I turn a list into a table?
Does sql require a server?
how many triggers are allowed in mysql table? : Sql dba
What are the operators used in select statements?