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

Answer Posted / swastik

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how tsql statements can be written and submitted to the database engine? : Transact sql

714


What is normalization in sql?

718


Write the command to remove all players named sachin from the players table.

922


What are the different types of constraints?

742


Why do you partition data?

726






How do I get sql certification?

704


how to get @@error and @@rowcount at the same time? : Sql dba

741


how to select unique records from a table? : Sql dba

825


i have some prob lem to tell me about my self in interview first round ...

1889


Does truncate remove indexes?

723


What is a unique constraint?

811


Is there a 64 bit version of ssms?

678


what is a primary key? : Sql dba

750


What is pl sql block structure?

719


What is the difference between having clause and where clause?

793