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 many ways to get the current time? : Sql dba

0 Answers  

what is the difference between granting and creating a view?

2 Answers  

What is asqueryable?

0 Answers  

What is dynamic sql in pl sql?

0 Answers  

explain advantages of myisam over innodb? : Sql dba

0 Answers  

Explain ttitle and btitle.

0 Answers  

What are sql triggers used for?

0 Answers  

What is relationship? How many types of relationship are there?

0 Answers  

Name some usages of database trigger?

0 Answers  

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

write a query to find 4th max salary

7 Answers  

What is auto increment in sql?

0 Answers