What is cursor ? And what is difference between Trigger ?
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 clustered index
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Explain how many types of relationship?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Will the writetext statement activate a trigger?
What is attribute? : sql server analysis services, ssas
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is replace and stuff function in sql server?
What is multi-statement table-value user-defined function?
What are subqueries in sql server?
Which are the olap features?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How retrieve field names from the table in SQL through JAVA code?
How you can add messages to the nt event log from within a stored procedure?