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 myisam tables? : Sql dba

1016

how to check myisam tables for errors? : Sql dba

1305

What is partition in sql query?

983

How can you select unique records from a table?

1054

Why we use join in sql?

945

How to call a javascript function from pl sql?

1119

What is use of package in pl sql?

995

What is flag in sql?

1017

what is user defined functions? : Sql dba

1018

What is sql architecture?

1035

What is sql dialect?

1098

what is “go” in t-sql? : Transact sql

1088

Can you select everything, but 1 or 2 fields, without writer's cramp?

971

How do I run sql profiler?

1051

Is it important to partition hard disk?

1005