Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31828 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 wide table?
How to provide column names in insert statements in ms sql server?
When you use @@error and try-catch?
Write query to return all rows sql?
What should be the fill factor for indexes created on tables? : sql server database administration
Does group by sort data?
How much is a sql server license?
What is change tracking in sql server?
What is the difference between the application object and session object?
What is a database in ms sql server?
What is onf in normalization form?
how would you store your query in an SSRS report or a Database server?
What is multi-statement table-value user-defined function?
Can a function call a stored procedure in sql server?
Introduction of rollup clause using sum and group by clause?
