What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 30761 Views
- HCL, Polaris, I also Faced
- E-Mail Answers
Answer Posted / adisha
CURSOR:
1.They are temporary work areas.
2.They are not stored independently in the database.
3.We can create cursor both implicitly and explicitly.
4.Cursors can take parameters.
5.They are used to process the result of query.
TRIGGER:
1.They are named PL SQL blocks.
2. They are stored in database.
3. They can be invoked automatically.
4. They cannot take parameters.
5. They are used to enforce data in dignity rules.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is an inner join?
What are the export options of ssrs?
How to recover from sql injection? : sql server security
What are the transaction properties?
Explain the steps to use transact-sql cursor?
What is a trigger? Why we need it?
What is difference between unique and primary key?
What is unique key constraint?
How to find out what is the default collation in a database?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Explain the truncate command?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Tell me about joins in database system and explain each in detail.
Explain what is row_number function?
Does index slows down insert statements?
