Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30130 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 auto increment?
Can we debug stored procedure?
How can get second highest salary in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can we join 3 tables in sql?
Does sql profiler affect performance?
what is foreign key? : Sql dba
how to show all tables with 'mysql'? : Sql dba
Why use triggers in sql?
What is the use of sqlerrd 3?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Can I create table without primary key?
what is union, minus and interact commands? : Sql dba
what is heap table? : Sql dba
What is dialect in sql?
