What is difference between a PROCEDURE & FUNCTION ?
- 6 Answers
- 10737 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / pankaj mehra
Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What makes a good primary key?
What is an ndf file?
Can you join a table to itself?
What is an exception in PL/SQL? What are the two types of exceptions?
How is a process of pl/sql compiled?
Name some usages of database trigger?
What is an example of translating a date into julian format?
Explain sql data types?
what is a table in a database ? : Sql dba
what is the difference between nested subquery and correlated subquery?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How can check sql version from command line?
how to increment dates by 1 in mysql? : Sql dba
what is the use of double ampersand (&&) in sql queries?
what is data control language? : Sql dba
