PLsql 从数据库中读取数据的小例子

开始

set serveroutput on;

  DECLARE
    v_ename emp.ename%TYPE;
  BEGIN
    select ename into v_ename from emp where empno=7369;
    dbms_output.put_line('ename is:'||v_ename);
  END;

结束