Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16852 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 sql catalog?
What is an ndf file?
How do you create a db file?
Can we debug stored procedure?
Is keyword pl sql?
What is sqlca in powerbuilder?
How many databases can sql express handle?
How to run sql*plus commands in sql developer?
what are the types of join and explain each? : Sql dba
What is cold data?
What is an alias command?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What are tables and fields?
What is sqlite used for?
Does truncate release storage space?
