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 is use of package in pl sql?

953

Explain architecture of sql server notification services?

989

Explain ttitle and btitle.

1058

What are analytic functions in sql?

972

how to run 'mysql' commands from a batch file? : Sql dba

1063

how to use regular expression in pattern match conditions? : Sql dba

966

State few characteristics of pl/sql?

931

what is a table in a database ? : Sql dba

991

Does varchar need length?

933

What is sql basics?

992

what is the syntax used for partition in tsql? : Transact sql

960

What is pl sql collection?

921

What is raid? How does it help storage of databases?

1034

Why cross join is used?

1025

what is union, minus and interact commands? : Sql dba

1123