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 schema in sql example?
What is the syntax and use of the coalesce function?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is row_number () in sql?
what is a relationship and what are they? : Sql dba
What is raid? How does it help storage of databases?
Is mariadb nosql?
What are sql data types?
What are tables in sql?
What is 19 null in sql?
What is a pl/sql block?
what are the different type of sql's statements ? : Sql dba
what is a table in a database ? : Sql dba
How do I find sql profiler?
What are secondary keys?