So I found this syntax to print '*' in a pattern but I have to do mine so they are in a single line. I been playing with the code to no success. Here is an example of what I am looking for:
The result I am searching for : **********************************
Here is the code that I been trying to reconstruct to reach my goal. Any help will be greatly appreciated.
set serveroutput on
set verfiy off
declare
v varchar2(250);
num number :=20 ;
begin
for i in 1..num loop
v := v || ' ' || '*';
dbms_output.put_line(v);
end loop;
end;