Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 30170 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
What is a clob in sql?
How to add a column ‘salary’ to a table employee_details?
How can we optimize a sql query?
What are tables and fields in the database?
what is sub-query? : Transact sql
Write a query to display the current date in sql?
How is a process of pl/sql compiled?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what is a constraint? Tell me about its various levels. : Sql dba
Does oracle use sql?
Is join same as left join?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
what is the difference difference between procedure and packages
What do you mean by “trigger” in sql?
What is a table partition?
