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

Is id a reserved word in sql?

668

Can a foreign key be a duplicate?

510

What is pl sql record in oracle?

567

How would you convert date into julian date format?

594

What is sql analyzer?

547

how to increment dates by 1 in mysql? : Sql dba

543

Is it important to partition hard disk?

536

What is trigger and types?

570

What is the difference between cluster and non-cluster index?

624

What do you mean by “trigger” in sql?

626

How does a covering index work?

535

what are the different index configurations a table can have? : Sql dba

577

How to read/write files from pl/sql?

584

Why do we go for stored procedures?

527

how can you create an empty table from an existing table? : Sql dba

665