What is difference between select statement and cursor
- 3 Answers
- 19550 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the types of joins in sql?
What is lookup table in sql?
What is application trigger?
explain normalization concept? : Sql dba
How to prepare for oracle pl sql certification?
What are the types of variable use in pl sql?
What is the use of pl/sql table?
Describe types of sql statements?
How do you create an update query?
What is localdb mssqllocaldb?
What is sqlerrd?
Does postgresql run on the cloud?
What is foreign key in sql with example?
Why do we use function in pl sql?
how to use like conditions? : Sql dba
