Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26710 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 is a view and how is it different from a table?
How to run create database statement?
How to upsert (update or insert into a table)?
What is snapshot is too old? Give and example for better understand.
How to pass parameters to procedures in oracle?
What is a system tablespace?
What is bulk collect in oracle?
How to delete a column in an existing table in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What privilege is needed for a user to delete rows from tables in another schema?
What is open database communication (odbc) in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
How to view the data files in the current database?
How to execute a stored program unit?
How to convert characters to numbers in oracle?
