Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16489 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 a temporal data type?
How can you fetch common records from two tables?
How to write pl sql program in mysql command prompt?
What are all types of user defined functions?
What is the advantage of nosql?
What are the three forms of normalization?
Can a composite key be null?
How do I order columns in sql?
what is user defined functions? : Sql dba
How exception handling is done in advance pl/sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
how is exception handling handled in mysql? : Sql dba
How do I run a script in sql developer?
Can we rename a column in the output of sql query?
What is localdb mssqllocaldb?
