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;

how to create temparary sequence

2 Answers   TCS,

What is pl sql architecture?

0 Answers  

What is a rank in sql?

0 Answers  

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

What is a data definition language?

0 Answers  

Which software is used for pl sql programming?

0 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

How do you declare a user-defined exception?

0 Answers  

Define commit?

0 Answers  

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

What is a database trigger?

0 Answers