Advantages and Disadvantages of Cursor?
- 15 Answers
- 97856 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
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is SQL Server?
How many categories of data types used by sql server?
Can sql server 2016 run on windows 7?
What are wait types?
What are the tool windows in sql server management studio? : sql server management studio
What’s the distinction between dropping a info and taking a info offline?
What authentication modes does sql server support?
How can i Relate Tables in SSIS
What do you understand by a view?
what's the information that can be stored inside a bit column? : Sql server database administration
How efficient you are in oracle and SQL server?
which backup strategy you are following at ur company
What is data modification?
In how many ways you can invoke ssrs reports?
