Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16107 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 can I see all tables in sql?
What is sqlite format?
What is pl sql commands?
how to delete an existing column in a table? : Sql dba
What is primary key in db?
What programs use sql?
How do you optimize a stored procedure in sql?
What are the different types of constraints?
What is an exception in PL/SQL? What are the two types of exceptions?
Why do we use view in sql?
What is mutating sql table?
what is a tablespace? : Sql dba
What steps server process has to take to execute an update statement?
What are the datatypes available in pl/sql ?
What does count (*) mean in sql?
