select lpad('*',rownum,'*') Star from dual connect by l

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

Question Posted / shivaindu

Answer Posted / shivaindu

select lpad('*',rownum,'*') Star from dual connect by level < 6;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is user in sql?

988

Are there any features that are decommissioned in 11g that are not present in 11g?

2092

What are the types of keys?

953

Does asenumerable execute the query?

1007

What is partition by in sql?

1018

Can we join same table in sql?

982

What is the purpose of the partition table?

1023

Name three sql operations that perform a sort.

971

What is the difference between view and stored procedure?

929

Where is sql database stored?

939

What are the advantages of normalization?

1051

Which one is better subquery or joins?

1029

What is bind reference and how can it be created?

989

What is exception? What are the types of exceptions?

1049

How would you convert date into julian date format?

966