what is difference between procedure and function
- 10 Answers
- 13006 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
How do I run a sql query?
What are sql triggers used for?
What is loop in pl sql?
What is normalization sql?
What is exit statement?
Is grant a ddl statement?
explain commit and rollback in mysql : sql dba
What are pl sql data types?
Is sql sequential or random?
How to check if a column is nullable before setting to nullable?
how mysql optimizes distinct? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
Does truncate remove indexes?
How do you explain an index number?
What is foreign key sql?
