what is difference between procedure and function
- 10 Answers
- 14669 Views
- MCN Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhendu
Functions called from SQL have special restrictions:
Accept only IN parameters
cannot contain DML
cannot contain DDL - implies COMMIT
Accept and return only SQL datatypes (not PL/SQL
specific datatypes)
Must use positional notation
Must own or have EXECUTE privilege
Cannot contain transactional or session control
statements (eg. COMMIT, ROLLBACK, ALTER)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Enlist the data types that can be used in pl/sql?
how to shutdown mysql server? : Sql dba
What view means?
How many types of indexes are there in sql?
What is difference between pl and sql?
What is date functions?
What is use of package in pl sql?
What is the best partition size for windows 10?
What is the use of function "module procedure" in pl/sql?
what is the difference between undefined value and null value? : Sql dba
How much does a sql dba make? : SQL DBA
Why is partition used in sql?
How to run pl sql program in mysql?
What are packages in pl sql and also explain its advantages?
What is error ora-01000: maximum open cursors exceeded
