What is difference between select statement and cursor

Answers were Sorted based on User's Feedback



What is difference between select statement and cursor..

Answer / 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

What is difference between select statement and cursor..

Answer / bolearner

The above answer is not so correct.

cursor can fetch rowid, rownum also from table.

The select into cant retrieve more than 1 record in plsql.

But cursor can retrieve more records that can be viewed for modified later in plsql.

Cursors has attributes like open,close,fetch,notfound. Those attributes not applicable in select..into clause.

finally select..into in plsql, just select column values and storing into plsql variable.

Is This Answer Correct ?    6 Yes 1 No

What is difference between select statement and cursor..

Answer / akash

Using select..into statement u cannot fetch more than 1 rows.
Beside naming the same select statement as cursor explicitly allows user to options like OPEN,CLOSE,FETCH.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is primary key and unique key?

0 Answers  


How do I view output in sql developer?

0 Answers  


what is a join? : Sql dba

0 Answers  


How you will create Toad Function?

1 Answers  


Does db2 use sql?

0 Answers  






What is a temporal table?

0 Answers  


how to extract a unit value from a date and time? : Sql dba

0 Answers  


How do you update a value in sql?

0 Answers  


What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,


Does access use sql?

0 Answers  


Explain some predefined exceptions.

0 Answers  


What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,


Categories