what is difference between procedure and function
- 10 Answers
- 13108 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
Does truncate free space?
What is row_number () in sql?
Explain two easy sql optimizations.
Which is faster subquery or join?
Can delete statement be rollbacked?
Is sql scripting language?
What is PL/SQL Records?
How many functions are there in sql?
what are the nonstandard string types? : Sql dba
Explain raise_application_error.
Does group by remove duplicates?
What are the two types of exceptions.
Can %notfound return null after a fetch?
How would you pass hints to the sql processor?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
