What is difference between select statement and cursor
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is the main difference between join and subqurey?
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
What can be a size of a pl/sql block? Is there any limit?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Which tcp/ip port does sql server run?
How do I turn a list into a table?
Can a table contain multiple foreign key’s?
How many types of keys are there in sql?
What is the relation b/w view and trigger
What are the different types of functions in sql?
Explain what is a view?
How to execute a stored procedure?