oracle脚本问题
我 一段
declare v_emp t_user_p.employee_id%type ;
cursor c_user is select t_user_p.employee_id from t_user_p ;
begin
open c_user;
loop
fetch c_user into v_emp ;
exit when c_user%NOTFOUND ;
if :v_emp = '09091214' then
goto X;
end if ;
-- DBMS_OUTPUT.PUT_LINE(:v_emp);
<<X>>
end loop ;
close c_user;
end
执行总是倒数第三行的end loop那里报错
declare v_emp t_user_p.employee_id%type ;
cursor c_user is select t_user_p.employee_id from t_user_p ;
begin
open c_user;
loop
end loop ;
close c_user;
end ;
这样执行还是倒数第三行的end loop报错,
去掉最后一行end后的分号还是end loop报错,
环境是pl/sql
请各位帮忙啊,刚用oracle,没想到搞一个脚本就难住了,在线等。
DECLARE
v_emp NUMBER;
CURSOR c_user IS
SELECT vendor_id from tsp_ems_t;
BEGIN
OPEN c_user;
LOOP
FETCH c_user
INTO v_emp;
EXIT WHEN c_user%NOTFOUND;
相关问答:
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
在执行包的时候引用oracle spatial空间函数出错,出错情况如下
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
各位大哥,帮个忙。
下个Oracle for vista 版本的安装试试
10G和11G的
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
在Oracle 数据库中怎么查前三条记录降序;
select * from
(select * from table order by col_name desc)
where rownum<=3;
select * from
(
select s.*,rownum rn
from t3 s
)
where ......