what is difference between procedure and function
- 10 Answers
- 13724 Views
- MCN Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aditi yadav
in addition to above answers -
1. Functions can be called inside procedure but procedure cannot be called inside functons.
2. Functions compiled every time when we call them whereas procedure compiles only once & can be called again and again without being compiled.
3. we can user functions in select statement but cannot use procedure.
4. Inside function we cannot user DML commands but inside procedures we can use DML commands.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the location of pre_defined_functions.
How do you pronounce sql?
What is java sql drivermanager?
What is the use of primary key?
What is composite primary key in sql?
How do you update a value in sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is the use of sql trace?
Whis is not false in primary key?
What is raw datatype in sql?
What is normalization? How many normalization forms are there?
What is multiple columns?
What is the difference between function and procedure in pl/sql?
What are the two characteristics of a primary key?
Can variables be used in sql statements?
