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

How much does sql certification cost?

1067

What does the hierarchical profiler does?

1048

Is sql a backend?

1003

Write a sql query to find the names of employees that begin with ‘a’?

991

What is union?

1137

Show how functions and procedures are called in a pl/sql block.

1101

Explain sql data types?

1077

What is the use of index in hive?

990

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1042

what is the different between now() and current_date()? : Sql dba

994

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1110

How can we find duplicate records in a table?

927

How do I start sql profiler?

978

What is the difference between inner join and left join?

972

What is a recursive stored procedure?

1160