select lpad('*',rownum,'*') Star from person where rown

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

Question Posted / kart

Answer Posted / kart

select lpad('*',rownum,'*') Star from person where rownum<6
*
**
***
****
*****

Is This Answer Correct ?

20 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How many functions are there in sql?

544

What is a loop in sql?

572

How can one get sql*loader to commit only at the end of the load file? : aql loader

574

What do we need to check in database testing?

561

What is trigger in pl sql with examples?

525

What are pl sql data types?

553

what are all different types of collation sensitivity? : Sql dba

527

What is a pragma statement?

724

what is primary key? : Sql dba

512

What are properties of the transaction?

562

Is sql database free?

535

what is the difference between union and union all? : Sql dba

548

Why partition by is used in sql?

558

how many values can the set function of mysql take? : Sql dba

539

how can we optimize or increase the speed of a mysql select query? : Sql dba

515