Answer Posted / anil kumar jampana
cursor is a private sql area. pl/sql cann't handle multy
row select statements. Inorder to handle mulyrow select
statements, we are using cursors.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What does sql stand for?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How many clustered indexes can be created on a table?
How to check if a column is nullable before setting to nullable?
Explain the components of sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Explain foreign key in sql?
Explain how to use transactions efficiently : transact sql
Explain the difference in execution of triggers and stored procedures?
what is union, minus and interact commands? : Sql dba
When is the explicit cursor used ?
Why is pl sql needed?
What is difference between mysql and postgresql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Does a join table need a primary key?