本文详细阐述了SQL查询操作的实现方式，并介绍了如何通过DBMS_OUTPUT进行输出，同时讨论了处理Too many rows returned异常的方法。
declare
v_description t11.description%type;
begin
select DESCRIPTION into v_description from t11;
dbms_output.put_line(v_description);
exception
when too_many_rows then
dbms_output.put_line('Too many rows are returned');
end;
v_description t11.description%type;
begin
select DESCRIPTION into v_description from t11;
dbms_output.put_line(v_description);
exception
when too_many_rows then
dbms_output.put_line('Too many rows are returned');
end;
扫一扫
3421
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
