从数据库SELECT一个数据,怎么把它赋值给变量

2025-05-19 10:17:49
推荐回答(1个)
回答1:

declare
v_ename emp.ename%type;
begin
select ename into v_ename from emp where empno=7369;
dbms_output.put_line(v_ename);
end;
/
以上select ename into v_ename from emp where empno=7369;
就把select出的ename数据赋值给了变量 v_ename,