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
What is gpt format?
How do you optimize a stored procedure in sql?
What are tables and fields?
How does rowid help in running a query faster?
What is the use of stored procedures?
Why is pl sql used?
What does dml mean?
How to get unique records from a table?
Can you skip header records while loading? : aql loader
How to add a column ‘salary’ to a table employee_details?
give the syntax of grant and revoke commands? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
Define overloaded procedure?
How to raise user-defined exception with custom sqlerrm ?
How to set up sql*plus output format in oracle?