Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30090 Views
- iFlex, I also Faced
- E-Mail Answers
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 a design view?
what are the different index configurations a table can have? : Sql dba
What is partition by in sql?
What is the difference between sql and t sql?
Can we use ddl commands in pl sql?
Is left join inner or outer?
What if we write return in procedure?
What is sqlservr exe?
what are all types of user defined functions? : Sql dba
what is the difference between nested subquery and correlated subquery?
What are the key differences between SQL and PL SQL?
What makes a good primary key?
What is sql key?
what are wild cards used in database for pattern matching ? : Sql dba
Does normalization improve performance?
