Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between select statement and cursor
- 3 Answers
- 21092 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
What is compute?
What is the execution plan in sql?
Are null values same as that of zero or a blank space?
Is sqlexception checked or unchecked?
How can you save or place your msg in a table?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is the best partition size for windows 10?
What is user defined functions?
What are the various levels of constraints?
What is the need of a partition key?
What are the types of operators available in sql?
How many types of normalization are there?
What are the advantages of pl sql?
Can a key be both primary and foreign?
How to select 10 records from a table?
