sql - PLSQL 过程输出具有奇怪的块

Question

我试图像下面的第一个屏幕截图一样显示，但我不明白我得到的输出（第二个屏幕截图）。

下面是我根据自己的数据库编写的 PLSQL 代码。如何摆脱输出中的那些奇怪的块？先谢谢了~

create or replace procedure numberOfSupplier (x int := 0 ) is

begin

for QRow in (SELECT REGION.R_NAME,NATION.N_NAME,COUNT(SUPPLIER.S_NATIONKEY) counter
         FROM REGION
         INNER JOIN NATION ON NATION.N_REGIONKEY=REGION.R_REGIONKEY
         INNER JOIN SUPPLIER ON SUPPLIER.S_NATIONKEY=NATION.N_NATIONKEY
         GROUP BY SUPPLIER.S_NATIONKEY,REGION.R_NAME,NATION.N_NAME
         HAVING COUNT(SUPPLIER.S_NATIONKEY)> x)

loop 

dbms_output.put_line ('R_NAME' || chr(18) || 'N_NAME' || chr(18) || 'COUNT(S_NATIONKEY)' || chr(10));

dbms_output.put_line (QRow.R_NAME || chr(18) || QRow.N_NAME || chr(18) || QRow.counter || chr(10));

end loop;
end;
/
show errors;

execute numberOfSupplier(130);

标签： sqloraclestored-proceduresplsql