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 clustered index in sql?

1040

how to get help information from the server? : Sql dba

915

How many sql commands are there?

1102

What does (*) mean in sql?

937

How to create a menu in sqlplus or pl/sql?

1100

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1022

How to make a copy values from one column to another in sql?

1021

What are triggers in sql?

1004

What is graph sql?

972

How do I run a query in pl sql developer?

975

What does fetching a cursor do?

1066

What is trigger with example?

1065

What is Histogram?

1548

what is a control file ? : Sql dba

1017

What does rownum mean in sql?

1008