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

Does user triggers have entry for trigger with compilation errors?

1039

What is data definition language?

1097

What are conditional predicates?

1064

what is 'mysqlcheck'? : Sql dba

1019

What are the rules to be applied to nulls whilst doing comparisons?

1324

Is subquery faster than join?

1018

Enlist the characteristics of pl/sql?

1804

What is sql profiler in oracle?

1099

what is the use of set statement in tsql? : Transact sql

1011

What are data types in pl sql?

1146

What are the limitations of sql express?

1072

What is trigger and types?

1030

What is serial sql?

980

Is sql scripting language?

1056

What is the default isolation level in sql server? : Transact sql

1032