What is the difference between a function and a procedure?

What will be an ideal response?


Procedures and functions are quite similar in construct in that they can accept input values and return values. However, a procedure is used to accomplish one or more tasks, return none or many values, and can be used only in PL/SQL statements. On the other hand, a function contains a RETURN clause and is used to manipulate data and return a single resulting value.

Business

You might also like to view...

Answer the following statements true (T) or false (F)

1. The budgeted multi-step income statements of both manufacturing and merchandising companies include the calculation of gross profit. 2. Use of advanced technology makes it more cost effective for managers to conduct sensitivity analysis. 3. Sensitivity analysis is a what-if technique. 4. Budgeting software is often designed as a component of the company's Enterprise Resource Planning (ERP) system.

Business

Under which of the following terms will the buyer be required to pay transportation costs?

A) FOB destination B) FOB shipping point C) freight out D) freight in

Business

Simulation may be capable of producing a more appropriate answer to a complex problem than can be obtained from a mathematical model

Indicate whether the statement is true or false

Business

Which of the following styles of communication focuses on precision and the use of the right amount of words to convey the message?

A. Elaborate B. Succinct C. Flexible D. Exacting

Business