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 is the difference between nvl function, ifnull function, and isnull function?
Why coalesce is used in sql?
What is pragma in pl sql?
What are variables in pl sql?
What are tables and fields in the database?
Name some usages of database trigger?
Which operator is used in query for pattern matching?
How many scalar data types are supported in pl/sql?
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 are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What does pragma mean?
Explain about various levels of constraint.
how to create a test table in your mysql server? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
how can I make a script that can be bi-language (supports english, german)? : Sql dba