Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16178 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 and its types?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is left join in postgresql?
what is self join and what is the requirement of self join? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
What are the disadvantages of file system?
What is the plv (pl/vision) package offers?
How do I run sql?
What are actual parameters and formal parameters?
What are the basic techniques of indexing?
What is data control language?
Is drop table faster than truncate?
Is nosql faster than sql?
What is break?
What is embedded sql with example?
