Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between select statement and cursor
- 3 Answers
- 21094 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
What is dynamic query?
What are commit, rollback, and savepoint?
What company owns postgresql?
Can you sum a count in sql?
What is primary key secondary key alternate key candidate key?
Which is faster joins or subqueries?
how to include comments in sql statements? : Sql dba
Is left join faster than inner join?
Define commit?
how to fetch alternate records from a table? : Sql dba
How to add, remove, modify users using sql?
What does select top 1 do in sql?
Can we use join in subquery?
What is primary key in db?
what are the advantages of using stored procedures? : Sql dba
