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


Please Help Members By Posting Answers For Below Questions

What is schema in sql example?

601


What is the syntax and use of the coalesce function?

606


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

523


What is row_number () in sql?

550


what is a relationship and what are they? : Sql dba

552






What is raid? How does it help storage of databases?

605


Is mariadb nosql?

586


What are sql data types?

550


What are tables in sql?

550


What is 19 null in sql?

536


What is a pl/sql block?

595


what are the different type of sql's statements ? : Sql dba

522


what is a table in a database ? : Sql dba

546


How do I find sql profiler?

522


What are secondary keys?

563