Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 29759 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / gvk
functions and procedures:
1.Functions Returns a value, procedure not return a value.
2.parsed & compiled at runtime, Procedure stored as a
pseudo code in database ie. Compiled form.
3.Cannot effect the state of database,sp effect the state
of database using Commit etc..
4.mainly used to compute the values, sp used to process the
tasks.
5.It can be invoked from sql statement :eg:select, sp can
not invoked.
6.it is not accept more than one argument.sp accept more
than one argument.
Trigger and procedure:
1.It is run Automatically , sp run it manually.
2.With in a trigger u can call the sp, with in a sp u can
not call the trigger.
3.when u r creating the trigger u have to identify event
and action of your trigger. not possible in sp.
4.Trigger not pass the arguments but sp pass the arguments.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how many columns can be used for creating index? : Sql dba
What is field delimiter?
Does sql*plus also have a pl/sql engine?
What is the example of procedure?
Write a sql query to get the third highest salary of an employee from employee_table?
What is the purpose of cursors in pl/sql?
What is procedure and function in sql?
Can we write dml inside a function in sql server?
What is multiple columns?
What is offset in sql query?
What is a call statement? Explain with an example.
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is program debugging?
Why do we use cursors?
What is sql entity?
