Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26376 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 an oracle recycle bin?
What is a nested table?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What are ddl statements in oracle?
How can we find out the current date and time in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
When do we use group by clause in a sql query?
How to check database size in Oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Oracle
Explain database link?
How to use "out" parameter properly?
Is oracle a programming language?
