create or replace view v_emp as
select employee_id,last_name,hire_date from emp;
create or replace procedure p_emp
as
int_count number;
begin
select count(*) into int_count from v_emp;
end;
create or replace function f_emp
return number
int_count number;
begin
p_emp;
return 1;
end;
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |