what is difference between procedure and function
- 10 Answers
- 14574 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
Explain correlated query work?
What are the different sql commands?
Can we use ddl statements in stored procedure?
What are the built in functions of sql?
What is a sql statement?
What are sql commands?
List the various privileges that a user can grant to another user?
What is the sql query to display the current date?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the example of procedure?
What is the size of partition table?
How can use stored procedures in sql?
how to use myisamchk to check or repair myisam tables? : Sql dba
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How are sql commands classified?
