Answer Posted / suresh somayajula
Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is composite primary key in sql?
What is primary key and unique key?
What is the difference between delete, truncate and drop command?
Can we use loop in sql?
Can you selectively load only those records that you need? : aql loader
How do you declare a variable in pl sql?
What are pl sql data types?
What is foreign key sql?
what are the types of subquery? : Sql dba
How many joins can you have in sql?
What is compilation error in pl sql?
What is having clause in sql?
What is sql and also describe types of sql statements?
Mention what plvcmt and plvrb does in pl/sql?