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
16811 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

how to include numeric values in sql statements? : Sql dba

1100

what is acid property in database? : Sql dba

1029

what is commit? : Sql dba

1078

What is an intersect?

1103

How sql query is executed?

1132

How do I run a pl sql program?

1130

Why do we need unique key in a table?

957

Can we join 3 tables in sql?

1043

What are different types of statements supported by sql?

1165

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1134

How can I tell if sql is running?

1066

Name the operator which is used in the query for pattern matching?

954

How do I run a sql script?

1149

How to handle bulk data?

1310

Can a procedure in a package be overloaded?

1045