What is difference between select statement and cursor
- 3 Answers
- 19531 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
How can we make an if statement within a select statement?
Explain the structure of pl/sql in brief.
What is the best free sql database?
What is a sql statement?
What are the different ddl commands in sql?
What is the difference between inner join and outer join?
what is self join and what is the requirement of self join? : Sql dba
What is sql partition function?
Show the two pl/sql cursor exceptions.
how do you control the max size of a heap table? : Sql dba
what is commit? : Sql dba
What is plpgsql language?
Which is faster count (*) or count 1?
Explain the types of joins in sql?
describe transaction-safe table types in mysql : sql dba
