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

Can we use joins in subquery?

1165

What is type and rowtype in pl sql?

1020

How does postgresql compare to "nosql"?

1036

what are properties of a transaction? : Sql dba

1094

How do I remove all records from a table?

1076

how to use like conditions? : Sql dba

1112

how to use case expression? : Sql dba

1031

How do you declare a constant?

962

When do we use triggers?

1084

What is a recursive join sql?

1077

Mention what plvcmt and plvrb does in pl/sql?

1143

What is the difference between microsoft access and sql?

1029

what is difference between delete and truncate commands? : Sql dba

1136

What is compiled query?

1041

What is sql character function?

1089