What is difference between select statement and cursor
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 do you use a while loop in pl sql?
what are the authentication modes in sql server? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
How do you change a value in sql?
What is a crud api?
How is a process of pl/sql compiled?
How to Execute a Package in PL/SQL.?
What is the cause of mutating table error and how can we solve it?
when MSQL8.0 is in market
what is 'mysqlshow'? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is the use of index in sql?
What's the difference between inner join and left join?
What is the difference between a procedure and a function?
What is sql select statement?