Question

oracle for循环

打印三角形

Answer 1

create or replace procedure test_yurui
(
p_line in number
) is
v_line number;
begin
v_line:=p_line;
if(v_line<1) then
dbms_output.put_line('请输入>=1的整数');
end if;

for v in 1..p_line loop
for m in 1..p_line-v loop
dbms_output.put(' ');
end loop;

for n in 1..2*v-1 loop
dbms_output.put('*');
end loop;

dbms_output.put_line('');
end loop;
end test_yurui;

-----------------------效果如下---------------------
输入6

*
***
*****
*******
*********
***********