Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16548 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
Give the order of sql select?
Is sql injection illegal?
What is the difference between having clause and where clause?
What is optimistic concurrency control? : Transact sql
What is a common use of group by in sql?
What does select count (*) mean in sql?
Define concurrency control. : Transact sql
What is the difference between left outer join and left join?
What is pl sql in dbms?
Which version of sql do I have?
How is indexing done in search engines?
What is the most common sql injection tool?
what are the drivers in mysql? : Sql dba
What are predefined functions in sql?
What is auto increment?
