一、准备表和数据;
1、创建表;
create table emp
(
empno varchar2(32),
ename varchar2(32),
job varchar2(32),
sal varchar2(32)
);
2、添加数据;
insert into emp(empno,ename,job,sal) values('2','张三1','MANAGER','2000');
insert into emp(empno,ename,job,sal) values('3','张三2','MANAGER','3000');
insert into emp(empno,ename,job,sal) values('4','张三3','MANAGER','4000');
insert into emp(empno,ename,job,sal) values('5','张三4','MANAGER','5000');
insert into emp(empno,ename,job,sal) values('6','张三5','MANAGER','6000');
二、编写游标;
--声明游标;CURSOR cursor_name IS select_statement
--For循环游标
--(1)定义游标
--(2)定义游标变量
--(3)使用for循环来使用这个游标
declare
--类型定义
cursor c_job is
select empno,ename,job,sal from emp where job='MANAGER';
--定义一个游标变量v_cinfo c_emp%ROWTYPE,该类型为游标c_emp中的一行数据类型
c_row c_job%rowtype;
begin
for c_row in c_job
loop
dbms_output.put_line(c_row.empno||'-'||c_row.ename||'-'||c_row.job||'-'||c_row.sal);
end loop;
end;