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 the difference between count 1 and count (*) in a sql query?

505

Explain the select statement in sql?

616

what is a foreign key ? : Sql dba

611

What is the use of count (*) in sql?

551

How to connect a sql*plus session to an oracle server?

624

what is a field in a database ? : Sql dba

547

What is tuple in sql?

547

What is the difference between pl and sql?

545

What is foreign key and example?

521

What are the indexing methods?

577

What is the use of function in sql?

541

What are all the different normalizations?

591

Which command is used to delete a trigger?

777

what is sql server agent? : Sql dba

605

What is dense_rank?

540