what is difference between procedure and function
- 10 Answers
- 14415 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
What is the importance of sqlcode and sqlerrm?
What is t sql used for?
Which command is used to call a stored procedure?
What is the difference between mdf and ndf files?
Is sqlite free?
What is autocommit sql?
How can you fetch first 5 characters of the string?
what is a field in a database ? : Sql dba
Can dml statements be used in pl/sql?
how to check server status with 'mysqladmin'? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
What are analytic functions in sql?
What is pivot query?
Explian rowid, rownum?
what is cursor. write example of it. What are the attributes of cursor.
