What are main difference between Stored Procedure and
Functions.
Answer Posted / preethi
another important difference between procedure and function
is inside procedure we can use DML statements but inside the
function only select can be used not delete and update.
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Can the query output be sorted by multiple columns in oracle?
How to find the duplicate rows count from employees table in oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to define and use table alias names in oracle?
What is hash cluster in oracle?
What are the general rules on data consistency?
Is insert autocommit in oracle?
Explain integrity constraint?
Explain the use of indexes option in imp command.
What is the oracle implicit cursor?
What is format trigger?
Why does Oracle not permit the use of PCTUSED with indexes?
What is archive log in Oracle?
Explain the use of control file?
Explain what are the uses of rollback segment?