Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between select statement and cursor
- 3 Answers
- 21101 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / akash
Using select..into statement u cannot fetch more than 1 rows.
Beside naming the same select statement as cursor explicitly allows user to options like OPEN,CLOSE,FETCH.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do we need cursors in pl sql?
what are the different functions in sorting an array? : Sql dba
What are local and global variables and their differences?
Why we use joins in sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
explain the advantages and disadvantages of stored procedure? : Sql dba
how many columns can be used for creating index? : Sql dba
How do you change a value in sql?
What is the difference between stored procedure and view?
What is a clob in sql?
What is the purpose of the partition table?
What is difference between stored procedure and trigger?
Are sql connections encrypted?
Where is sql database stored?
How do I count rows in sql query?
