What is cursor ? And what is difference between Trigger ?

Question Posted / devesh

3 Answers
31830 Views
HCL, Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is cursor ? And what is difference between Trigger ?..

Cursor is an Database object and retrive the rows from
database row by row ,
And it is maily use for ot reduce the network traffic
it contains 5 features
1.DECLARE the Cursor
2.OPEN the cusrsor
3.FETCH the cursor
4.CLOSE the cursor
5.DEALLOCATE the cursor

TRIGGER : IT is also an database object and You can
perform an anction Trigger will fire automatacallly.
like (DML,DDL)
They can cascade changes through related tables in the
database; however, these changes can be executed more
efficiently using cascading referential integrity
constraints.

They can guard against malicious or incorrect INSERT,
UPDATE, and DELETE operations and enforce other
restrictions that are more complex than those defined with
CHECK constraints.

Multiple DML triggers of the same type (INSERT, UPDATE, or
DELETE) on a table allow multiple, different actions to
take place in response to the same modification statement.

Is This Answer Correct ?

53 Yes

10 No

What is cursor ? And what is difference between Trigger ?..

Answer / sanjay kumar dinda

Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis, instead of
the typical SQL commands that operate on all the rows in
the set at one time.

Trigger is a database object invoked automatically when any
event occured.
These aevents are
Delete, Insert, Update etc....

SQL server store the intermediate data into to dummy table
INSERTED and DELETED...

At the time of insert operation SQL Server STores inserted
rows into the INSERTED table and at the time of delete or
update SQL Server stores the information into DELETED dummy
table

Is This Answer Correct ?

19 Yes

7 No

What is cursor ? And what is difference between Trigger ?..

Answer / 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