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

If a cursor is open, how can we find in a pl/sql block?

1176

Explain what is a field in a database and record in a database?

1103

What is a constraint? Tell me about its various levels.

1178

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1002

How to sort the rows in sql.

1085

what are properties of a transaction? : Sql dba

1099

What are the possible values that can be stored in a boolean data field?

1011

What is the process of copying data from table a to table b?

1103

How to display the current date in sql?

1091

Why do we need unique key in a table?

966

what are set operators in sql? : Sql dba

1062

Which table is left in left join?

1028

What are sql data types?

1037

Can pl sql procedure have a return statement?

1038

How does postgresql compare to oracle/db2/ms sql server/informix?

1045