select rownum rn from (select 1 from dual group by cube(1,2,3,4,5)) where

i want to display 1 to 10 numbers using one select statement.

Question Posted / srinivas

Answer Posted / srinivas

select rownum rn from (select 1 from dual group by
cube(1,2,3,4,5)) where rownum <=10

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can a key be both primary and foreign?

508

Is primary key a clustered index?

533

What is Collation Sensitivity ? What are the various type ?

497

What is the difference between delete and truncate statement in sql?

493

What is the use of pl/sql table?

556

What are the parts of a sql statement?

551

What is string join?

550

what are the authentication modes in sql server? How can it be changed? : Sql dba

701

What are the types of index in sql?

531

What operating systems are supported by oracle sql developer?

518

What is a loop in sql?

564

What is cursor status?

761

How many tables can you join in sql?

526

What is a primary key called that is made up of more than one field?

791

When you have to use a default "rollback to" savepoint of plvlog?

717