List the differences between plsql - function & procedures
Answer Posted / lavanya
functions:
1.The parameters are input values and output values
2.The functions will return a value
3.The functions will be called with in sql
Procedures:
1.The parameters are input values and output values
2.The procedures will not return any value
3.The procedures will not be called with in sql
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How is data stored on a disk?
What is delimiter sql?
How much does a sql dba make? : SQL DBA
What is self-join and what is the requirement of self-join?
How many types of primary keys are there?
Who is the owner of mysql database?
tell us something about heap tables. : Sql dba
How does sql profiler work?
what is a tablespace? : Sql dba
how to increment dates by 1 in mysql? : Sql dba
what is table? : Sql dba
Show the two pl/sql cursor exceptions.
How to find 3rd highest salary of an employee from the employee table in sql?
What type of database is cloud sql?
What is partition by in sql?