try:DECLARE
v_ename EMP.ENAME%TYPE;
v_accept date;
CURSOR c_emp IS SELECT enameFROM emp;
BEGIN
OPEN c_emp;
LOOP
EXIT WHEN c_emp%NOTFOUND;
FETCH c_emp INTO v_ename;
select jl_test(v_ename) into v_accept from dual;
DBMS_OUTPUT.PUT_LINE(v_accept );
END ;
v_ename EMP.ENAME%TYPE;
v_accept date;
CURSOR c_emp IS SELECT enameFROM emp;
BEGIN
OPEN c_emp;
LOOP
EXIT WHEN c_emp%NOTFOUND;
FETCH c_emp INTO v_ename;
select jl_test(v_ename) into v_accept from dual;
DBMS_OUTPUT.PUT_LINE(v_accept );
END ;
解决方案 »
- Oracle round函数使用
- 求一oracle查询语句
- Oracle中的datalink是怎么回事???那位大师能给我讲讲!!
- 怎样修改由show parameter命令显示出的参数的值?
- ERROR: ORA-03121: no interface driver connected - function not performed
- 重新建数据库的原因
- 关掉Oracle8i的managerServer服务之后 无法重起
- 急 Oracle的编程联机文档那里有(函数库)?
- 关于数据的插入(续)
- 我想用一个给定的关键字去匹配一个blob型的字段,请问该如何作
- SQLServer的SQL语句转换为Oracle的写法?急!
- 菜鸟求救oracle8i数据库恢复
try DECLARE
v_ename EMP.ENAME%TYPE;
v_accept date;
CURSOR c_emp IS SELECT enameFROM emp;
BEGIN
OPEN c_emp;
LOOP
FETCH c_emp INTO v_ename;
EXIT WHEN c_emp%NOTFOUND;
select jl_test(v_ename) into v_accept from dual;
DBMS_OUTPUT.PUT_LINE(v_accept );
END ;
select jl_test(v_ename) into v_accept from dual;
仍然是有结果输出的