declare
v_emp employees%Rowtype;
begin
select employeeid, firstname, salary
into v_emp.employeeid, v_emp.firstname, v_emp.salary
from employees
where employeeid = 109;
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.firstname || ' ' ||
v_emp.salary);
end;
v_emp employees%Rowtype;
begin
select employeeid, firstname, salary
into v_emp.employeeid, v_emp.firstname, v_emp.salary
from employees
where employeeid = 109;
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.firstname || ' ' ||
v_emp.salary);
end;
本文展示了一段PL/SQL代码示例,用于从employees表中根据特定employeeid选择员工的ID、姓名及薪资信息,并使用dbms_output.put_line显示查询结果。
19万+

被折叠的 条评论
为什么被折叠?



