存储过程面试实例

最新推荐文章于 2024-07-12 07:30:00 发布

中辽普坦

最新推荐文章于 2024-07-12 07:30:00 发布

阅读量1k

点赞数

分类专栏： Structure|Pattern|Algorithm 文章标签： jbpm table user object oracle 数据库

本文链接：https://blog.csdn.net/byondocean/article/details/5928426

版权

Structure|Pattern|Algorithm 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

oracle面试必备存储过程

declare 
cusor emp_cursor is 
select ename,deptno from emp;
begin
for emp_record in emp_cursor loop
  if emp_record.deptno =30 then
   dbms_output.put_line('ename is'|| emp_record.ename);
  end if;
end loop;
end;

create or replace procedure proc_emp
is 
  cursor emp_cursor is select ename,deptno from emp;
begin
  for emp_record in emp_cursor loop 
     if emp_record.deptno =30 then
       dbms_output.put_line('ename is'|| emp_record.ename);
     end if;
  end loop;
end proc_emp;

sql server 存储过程

create procedure proc_emp
as 
declare emp_cursor global for 
  select ename,deptno from emp
declare @ename varchar(20),@deptno varchar(20)

open emp_cursor
fetch next from emp_cursor into @ename,@deptno
while @@fetch_status =0
begin 
  insert into @TableSetAll1(ename,deptno) values(@ename,@deptno);
fetch next from emp_cursor into @ename,@deptno
end
close emp_cursor
deallocate emp_cursor 
end