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 do you mean by stored procedures?

1002

What is a Mapplet?

1116

How does cross join work?

936

What do you understand by pl/sql packages?

1058

How insert into statements in sql?

1065

How do I create a sql script?

1093

How do you optimize a query?

988

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1614

What is sql and its types?

1171

how many tables will create when we create table, what are they? : Sql dba

1065

How does sql store data?

898

what is a view? : Sql dba

1070

Can cursors be part of a trigger body?

1633

Why do we need sharding?

982

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2159