|
|
oracle存储过程定义list
134浏览 · 2023-07-07 14:39:03
Oracle存储过程可以定义一个输入参数、多个输出参数，也可以不带参数。以下是一个定义带有输入参数和输出参数的存储过程的示例：
```sql
CREATE OR REPLACE PROCEDURE get_employee_details(
p_employee_id IN NUMBER,
p_employee_name OUT VARCHAR2,
p_employee_salary OUT NUMBER
BEGIN
SELECT employee_name, salary
INTO p_employee_name, p_employee_salary
FROM employees
WHERE employee_id = p_employee_id;