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

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

Question Posted / kart

Answer Posted / kart

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

Is This Answer Correct ?

21 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what does the t-sql command ident_incr does? : Transact sql

1064

How can we debug in PL/SQL?

1125

How do you drop a trigger?

980

How do I delete a trigger?

957

Can a table contain multiple foreign key’s?

989

What is coalesce sql?

986

List the various privileges that a user can grant to another user?

1036

What is natural join in sql?

976

What is foreign key in sql with example?

919

How does join work in sql?

1003

What is %type in pl sql?

959

How many postgresql users are there, worldwide?

1054

Why do we need pl sql?

964

Are stored procedures faster than queries?

941

how can we know the number of days between two given dates using mysql? : Sql dba

1039