Answer / kart

select lpad('*',rownum,'*') Star from person where rownum<6
*
**
***
****
*****

Answer / shivaindu

select lpad('*',rownum,'*') Star from dual connect by level < 6;

Answer / swastik

SELECT
LPAD('*',ROWNUM,'*') Stars
FROM ALL_OBJECTS
WHERE ROWNUM <= 5

Answer / bijaylaxmi

declare
m number:=5;
n varchar2(30);
begin
for i in 1..m
loop
for j in 1..i
loop
n:=n||'*';
end loop;
dbms_output.put_line(n);
n:=null;
end loop;
end;

Answer / sdsd

no need for the script

Answer / shrikant tyagi in nucleus soft

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY
BE USING SCRIPT)

this is using script;


declare
type a1 is table of varchar2(100);
a a1;
b varchar2(100);
begin
select lpad('*',rownum,'*') bulk collect into a from
lea_agreement_dtl where rownum < 5;
for i in 1..a.count
loop
b:=b||' '||a(i);
end loop;
dbms_output.put_line(b);
end;

Answer / s m nadeem

Declare
type stars is table of varchar2(10);
v_star stars;
v_str varchar2(10);

Begin
select lpad('*', rownum, '*')
bulk collect
into v_star
from tab_star
where rownum < 6;

for i in 1 .. v_star.count loop
v_str := v_star(i);
dbms_output.put_line(v_str);
End loop;
End;

Answer / shrikant tyagi

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY
BE USING SCRIPT)

this is using script;


declare
type a1 is table of varchar2(100);
a a1;
b varchar2(100);
begin
select lpad('*',rownum,'*') bulk collect into a from
lea_agreement_dtl where rownum < 5;
for i in 1..a.count
loop
b:=b||' '||a(i);
end loop;
dbms_output.put_line(b);
end;

What are the benefits of triggers?

0 Answers  

Can %notfound return null after a fetch?

0 Answers  

What is triggering circuit?

0 Answers  

Why query optimization is needed?

0 Answers  

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

What is the most common sql injection tool?

0 Answers  

Is id a reserved word in sql?

0 Answers  

What is data control language (dcl)?

0 Answers  

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

What is the plv (pl/vision) package offers?

0 Answers  

How do I pipe the output of one isql to another?

0 Answers