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

How to select 10 records from a table?

650

Explain the difference between drop and truncate commands in sql?

534

how would you enter characters as hex numbers? : Sql dba

516

What are the possible values that can be stored in a boolean data field?

517

what are different types of keys in sql?

606

What is string data type in sql?

535

what is query cache in mysql? : Sql dba

577

Which is better cte or subquery?

542

What is latest version of sql?

527

Show the two pl/sql cursor exceptions.

614

What is before trigger?

556

How many sql statements are used? Define them.

576

How delete all records from table in sql?

554

What is on delete restrict?

541

What are stored procedures in mysql?

565