SELECT LPAD('*',ROWNUM,'*') Stars FROM ALL

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

Question Posted / swastik

Answer Posted / swastik

SELECT
LPAD('*',ROWNUM,'*') Stars
FROM ALL_OBJECTS
WHERE ROWNUM <= 5

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql injection owasp?

548

What is prepared statement in sql?

547

What is view? Can we update view

867

What is range partitioning?

522

what is view? : Sql dba

556

How do I use google cloud in sql?

542

What is clustered index in sql?

588

What is integrity in sql?

562

What is bulk compiling in pl/sql.?

609

How many times can we commit in a loop?

566

How do I clear the screen in sql plus?

551

What is not null in sql?

580

What is pl sql variable?

506

Whis is not false in primary key?

977

What is the use of <> sql?

554