Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between select statement and cursor
- 3 Answers
- 21114 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
Does sql use python?
What's the difference between a primary key and a clustered index?
how can we find the number of rows in a table using mysql? : Sql dba
Explain character-manipulation functions?
Can we rollback truncate?
What are the different sql commands?
Explain the the update statement in sql?
What is the difference between join and natural join?
How do I edit a stored procedure?
what is clause? : Sql dba
What trigger means?
What is the purpose of the primary key?
Is sql the best database?
What are predefined functions in sql?
How do I run a sql script?
