Interested to Buy Any Domain ? << Click Here >> for more details...
What is cursor ? And what is difference between Trigger ?
- 3 Answers
- 31674 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 user-defined function?
What command is used to rename the database?
Write a sql query to sort on different column name according to the parameters passed in the function?
How to read data in a table with "select" statements?
What are the types of processing and explain each? : sql server analysis services, ssas
How to replace null values in expressions using isnull()?
What are group functions in query statements in ms sql server?
What is an active database?
What is the purpose of the model database?
what is the primary use of the model database? : Sql server administration
What to check if a User database is locked?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Tell me about joins in database system and explain each in detail.
where the connection string store in the database
What is the use of sql profiler in sql server 2012?
