Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30427 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
Define tables and fields in a database
What is a native sql query?
What is restrict in sql?
What does closing a cursor do?
How to pronounce postgresql?
Is pl sql useful?
What are character functions in sql?
What is over () in sql?
What is the primary key?
How do I save a stored procedure?
What is field delimiter?
What are the different sql commands?
How do I count records in sql?
What is on delete set null?
what happens if you no create privilege in a database? : Sql dba
