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

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

Question Posted / shivaindu

8 Answers
16852 Views
BeBo Technologies, I also Faced
E-Mail Answers

Answer Posted / shivaindu

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

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger in flip flop?

1019

What is pivot query?

1084

What is dynamic query?

985

how to calculate expressions with sql statements? : Sql dba

1046

How do you take the union of two tables in sql?

996

How does postgresql compare to "nosql"?

1047

What is the difference between python and sql?

1014

What is online transaction processing (oltp)?

1027

How to select random rows from a table?

1086

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1049

what is union, minus and interact commands? : Sql dba

1197

What is tuple in sql?

1092

What are stuff and replace function?

1092

When to use inner join and left join?

970

What are the types of optimization?

967