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 self-join and what is the requirement of self-join?
What is sql keyword?
What is dynamic sql in pl sql?
Can a select statement fire a trigger?
Enlist some predefined exceptions?
what is clause? : Sql dba
How to call shell script from pl sql procedure?
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 are different sql data types?
What is use of term?
Is truncate ddl or dml?
What is ttitle and btitle?
what is view? : Sql dba
What is t sql in sql server?
Can a table contain multiple foreign key’s?
