1.循环遍历表的每一行,并且拼接成一个字符串,将结果打印出来
declare
str varchar2(20);
begin
for line in (select t.id,t.name from t3 t) loop
if line.id = 1 then
str:= line.id || ':' || line.name;
dbms_output.put_line(str);
end if;
end loop;
end;
/1.循环遍历表的每一行,并且拼接成一个字符串,将结果打印出来
declare
str varchar2(20);
begin
for line in (select t.id,t.name from t3 t) loop
if line.id = 1 then
str:= line.id || ':' || line.name;
dbms_output.put_line(str);
end if;
end loop;
end;
/
被折叠的 条评论
为什么被折叠?
