What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 25155 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
In which language oracle has been developed?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Give the various rollback segment states.
How to create a new table by selecting rows from another table?
Explain constraining triggers.
How to test null values?
How to connect ms access to oracle servers?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What are the various types of snapshots ?
How to define an anonymous block?
What is the difference between pre-select and pre-query?
When system tablespace is created?
What is a cognitive schema?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is the difference between PFILE and SPFILE in Oracle?
