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
What is a design view?
What is trigger in sql and its types?
Can we rollback delete command?
Why primary key is required?
How do you declare a constant?
What is the importance of sqlcode and sqlerrm?
What is difference between rank () row_number () and dense_rank () in sql?
What are different types of queries in sql?
What is sql entity?
Can I learn sql in a week?
Mention what does the hierarchical profiler does?
What are dml commands?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Can we write ddl statements in functions?
Can we create foreign key without primary key?
