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 are all the different types of indexes?

1092

what are all the common sql function? : Sql dba

1013

Describe different types of general function used in sql?

979

How does sql profiler work?

966

How can I change database name in sql?

1003

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1178

What is varchar example?

975

Can we use delete in merge statement?

1002

What is the difference between view and stored procedure?

913

Compare sql & pl/sql

1049

What is trigger types of trigger?

996

Is record in oracle pl sql?

904

How to write pl sql program in mysql command prompt?

1009

How to fix oracle error ora-00942: table or view does not exist

958

What are the types of triggers in sql?

1018