-
How to load many parameter input into PL/SQL Procedure ?
Pls kindly help suggest how to load many parameter input for update the table. I have two parameter to load it for each update statement.
update employee
set emp_name = &a
,emp_salary = &b;
Thank you very much.
Plammy
-
How to load many parameter input into PL/SQL Procedure ?
Pls kindly help suggest how to load many parameter input for update the table. I have two parameter to load it for each update statement.
update employee
set emp_name = &a
,emp_salary = &b;
CREATE OR REPLACE PROCEDURE upd_emp_proc(param_emp_name IN VARCHAR2, param_emp_salary IN NUMBER) IS
BEGIN
UPDATE employee
SET emp_name = param_emp_name,
emp_salary = param_emp_salary
WHERE EMPLOYEE_ID = whatever(parameter?);
END upd_emp_proc;
Andrej
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|