PL/SQLGroupby-Ora-01422:确切的fetch返回超过请求的行数

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

PL/SQLGroupby-Ora-01422:确切的fetch返回超过请求的行数

    SET SERVEROUTPUT ON FORMAT WRAP SIZE 12000
Declare
v_count number;
cursor carcur IS
SELECT * FROM i_car;
v_car carcur%ROWTYPE;
Begin
Select COUNT (registration)
INTO v_count
from i_booking
group by registration;
FOR v_car IN carcur LOOP
DBMS_OUTPUT.PUT_LINE('Registration:'|| '  '|| v_car.registration);
DBMS_OUTPUT.PUT_LINE('Car Group:'|| ' ' ||v_car.car_group_name);
DBMS_OUTPUT.PUT_LINE('Model Name:'|| ' '||v_car.model_name);
DBMS_OUTPUT.PUT_LINE('Cost:'|| ' '||v_car.cost);
DBMS_OUTPUT.PUT_LINE('Total Bookings:'|| ' '||v_count);
DBMS_OUTPUT.NEW_LINE;
END LOOP;
End;

declare
v_count number;
v_counts is table of v_count
Begin
    Select COUNT (registration)
    bulk collect INTO v_counts
    from i_booking
group by registration;
if (v_counts > 0) then
   for i in v_counts.first..last loop
    <do your printing>
   end loop;
end if;
/

registration | other columns ...
1            | ...
1            | ...
1            | ...
2            | ...
3            | ...
3            | ...

registration | count(registration)
1            | 3
2            | 1
3            | 2

SET SERVEROUTPUT ON FORMAT WRAP SIZE 12000
    Declare
    v_count number;
    cursor carcur IS
    SELECT * FROM i_car;
    v_car carcur%ROWTYPE;
    Begin
    FOR v_car IN carcur LOOP
    Select COUNT (registration)
    INTO v_count
    from i_booking
    WHERE registration = v_car.registration;
    DBMS_OUTPUT.PUT_LINE('Registration:'|| '  '|| v_car.registration);
    DBMS_OUTPUT.PUT_LINE('Car Group:'|| ' ' ||v_car.car_group_name);

推荐文章

不拘小节的咖啡豆 · DetourAttach · microsoft/Detours Wiki · GitHub

2 月前

可爱的石榴 · 標註 x64 反組譯碼 - Windows drivers | Microsoft Learn

1 年前

帅气的瀑布 · [Day 22] Vue Quasar 彈跳視窗 2 - Dialog - iT 邦幫忙::一起幫忙解決難題，拯救 IT 人的一天

1 年前

成熟的充电器 · 在R中求一致性指数( Harrell'concordance index:C-index)案例 - 生信人

2 年前

开心的足球 · Only Candidates Carrying Covid Negative RT-PCR Test Report/ Fully Vaccinated Will Be Allowed To Enter The Campus. - Minerva

2 年前

PL/SQLGroupby-Ora-01422:确切的fetch返回超过请求的行数

4 个回答