Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31495 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
Explain log shipping and mention its advantages.
Which tcl commands are available on the sql server?
Explain about system stored procedure?
Can we perform backup restore operation on tempdb? : sql server database administration
How to make a remote connection in a database?
Do I need a report server to run reports in my application?
Explain indexes disadvantages?
What does sql server mean?
How to test a dml trigger in ms sql server?
How do I open port 1433?
What is a covered index?
List out the difference between union and union all in sql server?
Explain timestamp datatype?
Explain what are sparse columns?
How to assign null values to variables or columns?
