What is difference between select statement and cursor
Answer Posted / gudekotas
SELECT STATEMENT CONTAINS PARTICULAR STRUCTURE AND SELECT
QUERY RESULT SET CONTAINS ROWID,ROWNUM.
CURSOR DOESN'T CONTAIN STRUCTURE AND IT IS
VIRTUAL(CONTEXAREA)MEANS NO ROWID,NO ROWNUM.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is memory optimized table?
Why is pl sql needed?
What is the difference between instead of trigger and after trigger?
How does an execution block start and end in pl sql?
tell me about various levels of constraint. : Sql dba
What are aggregate and scalar functions?
How can you fetch common records from two tables?
Explain the difference between triggers and constraints?
What is dynamic query?
Why stored procedures are faster than query?
when is the use of update_statistics command? : Sql dba
Are sql connections encrypted?
What schema means?
What is a dirty read sql?
what is 'mysqlcheck'? : Sql dba