filmov
tv
oracle 11g pl sql fetch record

Показать описание
--set serveroutput on
--prompt 'enter employee number: '
--accept n
define n=7499
declare
begin
select ename, job, hiredate into name, job_desc, joining_date from emp where empno=&n;
end;
/
--prompt 'enter employee number: '
--accept n
define n=7499
declare
begin
select ename, job, hiredate into name, job_desc, joining_date from emp where empno=&n;
end;
/