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

How to take user input in pl sql?

1172

What is the difference between inner join and natural join?

1020

Why do we need databases?

1056

What is the purpose of primary key?

1042

what is a control file ? : Sql dba

1048

How do I remove duplicates in two columns?

1083

Why do we use procedures?

966

what is the difference between truncate and drop statements? : Sql dba

1140

What is package in pl sql?

1034

What is package in pl sql with an examples?

1052

Is vs as in pl sql?

996

What is difference between stored procedures and application procedures?

1026

What is an alias command?

1074

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

1062

Explain the steps needed to create the scheduled job?

1048