預存程序面試執行個體

oracle面試必備預存程序

declare cusor emp_cursor is select ename,deptno from emp;beginfor 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_empis   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_empas declare emp_cursor global for   select ename,deptno from empdeclare @ename varchar(20),@deptno varchar(20)open emp_cursorfetch next from emp_cursor into @ename,@deptnowhile @@fetch_status =0begin   insert into @TableSetAll1(ename,deptno) values(@ename,@deptno);fetch next from emp_cursor into @ename,@deptnoendclose emp_cursordeallocate emp_cursor end