what is the difference between trigger and storedprocedures

Answer Posted / poonam

Actually triger in action which is performed automatically
before or after a event occur and stored procedure is a
procedure which is executed when the it is called. Stored
procedure is module.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is full join?

521


Does truncate remove indexes?

555


Why do we use %rowtype & %type in plsql?

595


What is %s in sql?

560


what are the difference between clustered and a non-clustered index? : Sql dba

519






Why is %isopen always false for an implicit cursor?

565


How much does a sql dba make? : SQL DBA

501


How many joins in sql?

543


What is foreign key in sql with example?

508


How to move files from one directory to another in pl sql?

637


How do I debug a stored procedure?

622


Write an sql query to select all records from the table?

551


How do we use distinct statement? What is its use?

542


What is a composite primary key?

577


Can we insert data into materialized view?

499