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
Can we rename a column in the output of sql query?
Does truncate require commit?
What does pl sql stand for?
What are tables and fields?
Are subqueries faster than joins?
What is normalisation and its types?
Which tcp/ip port does sql server run?
How to pronounce postgresql?
What are records give examples?
Define the select into statement.
What are the disadvantages of not performing database normalization?
Explain the difference between sql and mysql.
What is basic structure of pl sql?
Can a composite key be null?
What does count (*) mean?