Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between select statement and cursor
- 3 Answers
- 20913 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 sql and its types?
what is myisam? : Sql dba
Explain what is dbms?
How do I view tables in mysql?
What is a temp table?
How to rename a column in the output of sql query?
How would you reference column values before and after you have inserted and deleted triggers?
Why do we need databases?
How to run sql*plus commands in sql developer?
What is difference between primary and secondary key?
What is using in sql?
How to start the command-line sql*plus?
What are sql functions? Describe the different types of sql functions?
Explain the steps needed to create the scheduled job?
Write a sql query to convert all character to uppercase after hypen.
