what is difference between procedure and function,
procedure and trigger?
Answer Posted / arup ratan banerjee
Procedure and Function
----------------------
1)Function return atleast one value
Procedure may or may not return value
2)Function can be a part of expression
Procedure can't be a part of exception
Procedure and Trigger
----------------------
Procedure need to be executed explicitly
Trigger gets automatically executed when insert update or
delete is fired on a table.
commit can be done in procedure
commit cannot be done in case of triggerrs except for
autonomous transactions
Is This Answer Correct ? | 47 Yes | 4 No |
Post New Answer View All Answers
What is write ahead logging in sql server?
what is heap table? : Sql dba
What are the uses of merge?
What is the usage of sql functions?
What is a pdo connection?
how to include character strings in sql statements? : Sql dba
what is log shipping? : Sql dba
Does a primary key have to be a number?
Is sql port 1433 encrypted?
how to fetch alternate records from a table? : Sql dba
Which software is used for pl sql programming?
What is your daily office routine?
Explain correlated query work?
What are the query optimization techniques?
What information is needed to connect sql*plus an oracle server?