Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 101392 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / navneet chandra
Hi All,
In pl/sql if you want perform some actions more than one
records you should user these cursors only. By using these
cursors you process the query records. you can easily move
the records and you can exit from procedure when you
required by using cursor attributes.
disadvantage:
using implicit/explicit cursors are depended by Situation.
If the result set is less than 50 or 100 records it is
better to go for implicit cursors. if the result set is
large then you should use explicit cursors. other wise it
will put burden on CPU.
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
If we delete pack Spec what will be the status of pack Body ?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What are the different methods available under sqlcommand class to access the data?
How do you create a data source?
What is the name of reporting services config file and what’s it’s used for?
Explain data warehousing in sql server?
Define left outer join in sql server joins?
What are sub reports and how to create them?
Can we insert data into view sql server?
How can I add Reporting Services reports to my application?
What is proper subset of candidate key?
What is normalization? Explain its different types?
what is the system function to get the current user's user id? : Sql server database administration
What are the lambda triggers?
What is difference between rownum and rowid?
