用游标实现在命令行窗口显示出部门号以及对应的部门名称。 declare
cursor a_dept is select deptno,dname from dept;
deptno1 dept.deptno%type;
dname1 dept.dname%type;
begin
open a_dept;
loop
fetch a_dept into deptno1,dname1;
dbms_output.put_line(deptno1||' 'dname1);
exit when a_dept%notfound;
END loop;
close a_dept;
END;这是我写的,有问题刚学,求指导,求教育!
cursor a_dept is select deptno,dname from dept;
deptno1 dept.deptno%type;
dname1 dept.dname%type;
begin
open a_dept;
loop
fetch a_dept into deptno1,dname1;
dbms_output.put_line(deptno1||' 'dname1);
exit when a_dept%notfound;
END loop;
close a_dept;
END;这是我写的,有问题刚学,求指导,求教育!
解决方案 »
- oracle导入问题
- 在创建目录的时候create directory .....后面的目录如果不在本地,是远程服务器的下的共享目录,如何来实现这个功能呢?
- oracle中如何用语句创建带有注释和默认值的表
- 急:ORA-00439错误.
- inner/left/right join 和 (+) 的区别
- 问2个性能相关的问题
- 老难了!谁能说出以下在ORACLE中语句的具体含义,具体点马上放分!
- 用sql 语句怎么使oracle的序列增加1?
- 如何进行UTL_FILE的异常捕捉
- 求分割字符串兼插入数据库的 oracle储存过程。
- 有无人知使用oralce制作的网页,对服务器有什么要求?
- oracle数据查询
CURSOR a_dept IS SELECT deptno,dname FROM dept;
deptno1 dept.deptno%TYPE;
dname1 dept.dname%TYPE;
BEGIN
OPEN a_dept;
LOOP
FETCH a_dept INTO deptno1,dname1;
-- 已经修改
dbms_output.put_line(deptno1 || ' ' || dname1);
EXIT WHEN a_dept%NOTFOUND;
END LOOP;
CLOSE a_dept;
END;
输出结果:10 ACCOUNTING
20 RESEARCH
30 SALES
40 OPERATIONS
40 OPERATIONS
declare
cursor a_dept is
select deptno, dname from dept;
deptno1 dept.deptno%type;
dname1 dept.dname%type;
begin
open a_dept;
loop
fetch a_dept
into deptno1, dname1;
dbms_output.put_line(deptno1 || '-----' ||dname1); --这个地方你写的有问题
exit when a_dept%notfound;
END loop;
close a_dept;
END;10-----ACCOUNTING
20-----RESEARCH
30-----SALES
40-----OPERATIONS
40-----OPERATIONS
PL/SQL procedure successfully completed
cursor a_dept is select deptno,dname from dept;
deptno1 dept.deptno%type;
dname1 dept.dname%type;
begin
open a_dept;
loop
fetch a_dept into deptno1,dname1;
exit when a_dept%notfound;
dbms_output.put_line(deptno1||' '||dname1);
END loop;
close a_dept;
END;
这样试试