what is difference between procedure and function
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
How do you use collections in procedure to return the resultset?
What is count * in sql?
Explain about various levels of constraint.
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Why is nosql good?
What are the advantages of normalization?
What is foreign key and example?
Explain ddl statements in pl/sql?
What is sql in oracle?
Why cross join is used?
What is dialect in sql?
What are analytic functions in sql?
Can we insert in sql function?
What is set transaction?
What is trigger types of trigger?