What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 24227 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
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
What are privileges and grants?
Why does Oracle not permit the use of PCTUSED with indexes?
How to update a table row with a record?
How to export your own schema?
Explain what are the uses of rollback segment?
What is the difference between 10g OEM and 11g OEM?
What is Data Dictionary Cache in Oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Explain the use of parfile option in exp command.
What is the difference between substr & instr functions?
Explain the use of Merge statement in oracle 11g
How to set a transaction to be read only in oracle?
Give syntax for SQL and ORACLE joins.
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to declare a local variable?
