what is difference between procedure and function,
procedure and trigger?

Answer Posted / suresh somayajula

Difference between Procs & Triggers is;

We have control over the firing of Stored Proceudres,
but we don't have control over the firing of Database
Triggers.

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is keyword pl sql?

649


What does seeding a database mean?

606


Can we join same table in sql?

650


What is the difference between function and procedure in pl/sql?

636


What is the difference among union, minus and intersect?

634






What does pl sql developer do?

604


Is left join same as inner join?

636


Differentiate pl/sql and sql?

649


Is time a data type in sql?

560


what are the features and advantages of object-oriented programming? : Sql dba

625


Is it possible to pass parameters to triggers?

664


What is secondary key?

592


How many types of indexes are there in sql?

621


What is a mutating table and a constraining table?

665


how can we destroy the session, how can we unset the variable of a session? : Sql dba

636