Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100891 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
How to view existing indexes on an given table using sp_help?
What is the query and subquery?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is cte (common table expression)?
How to sort query output in descending order in ms sql server?
What do you understand by mirroring and mention the advantages of the mirroring?
How use inner join in sql server?
Write a program to fetch first 10 records from a file?
What is sql server programming?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How will you monitor replication latency in transactional replication? : sql server replication
What are logical/boolean operations in ms sql server?
Can we install sql server 2016 on windows 7?
How to get the definition of a stored procedure back?
