declare tag_hight number;
hight integer;
tag_body number;
bodytype number;
begin
tag_hight:=1;
hight:=160;
while(tag_hight<4) loop
--exit when tag_hight>3;
tag_body:=1;
bodytype:=130;
while(tag_gbdy<4)
loop
--exit when tag_body>3;
insert into YU values(tag_hight,'XX','YYY',to_char(bodytype)||'/'||to_char(hight)||'b','0');
bodytype:=bodytype+2;
tag_body:=tag_body+1;
end loop
tag_hight:=tag_hight+1;
hight:=hight+5;
end loop;
end;提示 tag_hight:=tag_hight+1; 这出错,无效的语句?
第一次写这个,高手指点下
解决方案 »
- executeQuery(“select * from tablea ;”)
- 如何把有断行的段落取出来时只显示一行?
- oracle 正负抵消记录?
- SQL记录练号显示问题求解
- 路过的兄弟,help一下.
- 创建表空间时出错:'c:\oracle\oradata\cnc\lgy.ora'出错,无法创建文件,无法打开文件,系统找不到指定的路径!
- 简单问题请教:建表和修改表
- 一个字段存储的内容很大的时候,显示的时候能不能做分页处理,有没有具体的办法呢?
- 求教一个统计矩阵的写法。详见内文。多谢。
- 求助:查询优化
- 求CNOUG论坛(oracle.com.cn)邀请码一个 非常谢谢!!
- Oracle10G:ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务:?网上搜了一堆,全是说listener.ora文件中有问题,但我怎么也没整好?
SQL> select * from t; ID IDNAME TYPE
--- ------------ ----SQL>
SQL> declare
2 tag_hight number;
3 hight integer;
4 tag_body number;
5 bodytype number;
6 begin
7 tag_hight:=1;
8 hight:=160;
9 while(tag_hight<4) loop
10 tag_body:=1;
11 bodytype:=130;
12 while(tag_body<4)
13 loop
14 insert into t values(1,'a',1);
15 bodytype:=bodytype+2;
16 tag_body:=tag_body+1;
17 end loop;
18 tag_hight:=tag_hight+1;
19 hight:=hight+5;
20 end loop;
21 end;
22 /PL/SQL procedure successfully completedSQL> select * from t; ID IDNAME TYPE
--- ------------ ----
1 a 1
1 a 1
1 a 1
1 a 1
1 a 1
1 a 1
1 a 1
1 a 1
1 a 19 rows selectedSQL>
/*
public static void ss() {
int a = 10;
int b = 20;
for (; b - a > 1; a++) {
System.out.println(1);
}
}
*/--FOR
DECLARE
a number := 10;
b number := 20;
count number := 0;
BEGIN
FOR count IN a..b LOOP
DBMS_OUTPUT.PUT_LINE(1);
END LOOP;
END; --WHILE
DECLARE
a number := 10;
b number := 20;
count number := 0;
BEGIN
WHILE a<b LOOP
DBMS_OUTPUT.PUT_LINE(1);
a := a+1;
END LOOP;
END; --LOOP
DECLARE
a number := 10;
b number := 20;
count number := 0;
BEGIN
LOOP
IF a<b THEN
DBMS_OUTPUT.PUT_LINE(1);
a := a+1;
END IF;
END LOOP;
END;