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 sql comments?
What is dml and ddl?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is the difference between unique and primary key constraints?
What is the order of sql select?
What is break?
Can you rollback after commit?
Explain the uses of database trigger.
What is linq to sql?
Can I learn sql in a week?
How sql query is executed?
How do you concatenate in sql?
How do you sort in sql?
Why is stored procedure faster than query?
How would you convert date into julian date format?