在PL/SQL中，過程（procedure）與函數(shù)（function）的核心區(qū)別在於用途和返回值：1. 過程用於執(zhí)行操作，不強(qiáng)制返回值，但可通過OUT參數(shù)返回多個(gè)值；2. 函數(shù)用於計(jì)算並返回單個(gè)值，常用於表達(dá)式或SQL語句中；例如，update_salary過程可執(zhí)行更新操作，而get_bonus函數(shù)則返回計(jì)算出的獎(jiǎng)金數(shù)額；過程適用於數(shù)據(jù)修改和多輸出場(chǎng)景，函數(shù)適用於需嵌入SQL中的計(jì)算邏輯；此外，函數(shù)可在過程中調(diào)用，但過程不可直接在SQL語句中調(diào)用。

In PL/SQL, the main difference between a procedure and a function comes down to their purpose and how they're used. Procedures are meant for performing actions, while functions are designed to compute and return a value.

What a Procedure Does

A procedure is like a small program that does something—like inserting data, updating records, or performing a series of SQL operations. It doesn't have to return anything, although it can use OUT parameters to send values back.

For example:

 CREATE OR REPLACE PROCEDURE update_salary (emp_id IN NUMBER) IS
BEGIN
   UPDATE employees
   SET salary = salary * 1.1
   WHERE employee_id = emp_id;
END;

You'd call this with:

 EXEC update_salary(101);

• Procedures are good when you don't need a direct return value.
• They can modify data or perform logic without needing to give something back immediately.
• You can use them in anonymous blocks or call them from other procedures.

How a Function Is Different

A function, on the other hand, must return a value. That makes it useful in expressions or SQL statements where a value is expected.

Here's a basic function:

 CREATE OR REPLACE FUNCTION get_bonus (emp_id IN NUMBER) RETURN NUMBER IS
   bonus_amt NUMBER;
BEGIN
   SELECT salary * 0.1 INTO bonus_amt
   FROM employees
   WHERE employee_id = emp_id;

   RETURN bonus_amt;
END;

And you'd use it like this:

 SELECT get_bonus(101) FROM dual;

• Functions are ideal when you need to calculate and return a result.
• They're often used inside SQL queries or assignments.
• Be careful: if your function has DML (like INSERT or UPDATE), you might run into issues using it directly in SQL unless you define it with PRAGMA AUTONOMOUS_TRANSACTION or allow side effects.

When to Use Which

Use a procedure when:

• You're doing an action rather than calculating a value.
• You want to change data (like inserts, updates, deletes).
• You need multiple outputs via OUT parameters.

Use a function when:

• You need to return a single value for use elsewhere.
• You plan to call it inside a SQL query or expression.
• The logic is more about transformation or calculation than modification.

Also keep in mind:

• Functions can be called from within procedures.
• Procedures can't be directly called from a SQL statement unless wrapped in a function or used via a ref cursor.

So, basically:

• Procedures do things , optionally returning values through OUT parameters.
• Functions return a value , and are usually used where a computed result is needed.

That's the core distinction — not too complicated once you see how each fits into real usage.

以上是PL/SQL中的過程和功能有什麼區(qū)別？的詳細(xì)內(nèi)容。更多資訊請(qǐng)關(guān)注PHP中文網(wǎng)其他相關(guān)文章！