请问我的这个写法哪里错了?
declare
i number;
j number;
k number;
r char;
b char;
l char;
begin
for i in 1..2 loop
for j in 1..5 loop
for k in 1..26 loop
r:=to_char(i,'00'); /行
b:=to_char(k,'00'); /列
l:=to_char(j,'00'); /层
insert into LOC_MST(loc,loc_sts,Row_X,Bay_Y,LVL_Z,Plt_Typ,temp_Are)
values(r||b||l,N,r,b,l,A,L);
end loop;
end loop;
end loop;
end;
declare
i number;
j number;
k number;
r char;
b char;
l char;
begin
for i in 1..2 loop
for j in 1..5 loop
for k in 1..26 loop
r:=to_char(i,'00'); /行
b:=to_char(k,'00'); /列
l:=to_char(j,'00'); /层
insert into LOC_MST(loc,loc_sts,Row_X,Bay_Y,LVL_Z,Plt_Typ,temp_Are)
values(r||b||l,N,r,b,l,A,L);
end loop;
end loop;
end loop;
end;
解决方案 »
- sql plus和sqlplus worksheet的工作流程是怎么样的?
- oracle Rman 异机数据备份和恢复问题???
- 用语句如何导出数据为excel文件
- oracle8i客户端和9的客户端字符集不一样,故软件在启动时会出现乱码,如何一次性解决版本引起的字符集冲突????
- 求一统计SQL
- 求免费ORCAL电子版教程
- 上海某外企诚聘Oracle顾问-----月薪10000RMB+
- 初学者几简单问题
- 请教个问题~~~~~~SQl的查询
- 求教一个比较奇怪的ORACLE中文乱码问题
- 高手帮忙,用TOAD连接服务器数据库后,查看表信息时报错“ORA-01640:转换请求无法实现或不合理”,是什么问题?
- 关于java.sql.SQLException: No more data to read from socket
declare
i number;
j number;
k number;
r char;
b char;
l char;
begin
for i in 1..2 loop
for j in 1..5 loop
for k in 1..26 loop
r:=to_char(i,'00');
b:=to_char(k,'00');
l:=to_char(j,'00');
insert into LOC_MST(loc,loc_sts,Row_X,Bay_Y,LVL_Z,Plt_Typ,temp_Are)
values(r||b||l,N,r,b,l,A,L);
end loop;
end loop;
end loop;
end;
i NUMBER;
j NUMBER;
k NUMBER;
r CHAR(10);
b CHAR(10);
l CHAR(10);
BEGIN
set serveroutput on size 100000;
DECLARE
i NUMBER;
j NUMBER;
k NUMBER;
r CHAR(10);
b CHAR(10);
l CHAR(10);
BEGIN
FOR i IN 1 .. 2
LOOP
FOR j IN 1 .. 5
LOOP
FOR k IN 1 .. 26
LOOP
r := TO_CHAR (i, '00');
b := TO_CHAR (k, '00');
l := TO_CHAR (j, '00'); insert into LOC_MST(loc,loc_sts,Row_X,Bay_Y,LVL_Z,Plt_Typ,temp_Are)
values(trim(r)||trim(b)||trim(l),N,r,b,l,A,L);
END LOOP;
END LOOP;
END LOOP;
END;
总是values(trim(r)||trim(b)||trim(l),N,r,b,l,A,L);报错
set serveroutput on size 100000;
DECLARE
i NUMBER;
j NUMBER;
k NUMBER;
r CHAR(10);
b CHAR(10);
l CHAR(10);
BEGIN
FOR i IN 1 .. 2
LOOP
FOR j IN 1 .. 5
LOOP
FOR k IN 1 .. 26
LOOP
r := TO_CHAR (i, '00');
b := TO_CHAR (k, '00');
l := TO_CHAR (j, '00'); insert into LOC_MST(loc,loc_sts,Row_X,Bay_Y,LVL_Z,Plt_Typ,temp_Are)
values(trim(r)||trim(b)||trim(l),'N',r,b,l,'A','L');
END LOOP;
END LOOP;
END LOOP;
END;
insert into LOC_MST(loc,loc_sts,Row_X,Bay_Y,LVL_Z,Plt_Typ,temp_Are)
values(trim(r)||trim(b)||trim(l),'N',r,b,l,'A','L');