select rownum from dual connect by level <=10;

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

Question Posted / pramod kumar behera

Answer Posted / pramod kumar behera

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sql commands?

1010

What is Histogram?

1557

How can the performance of a trigger be improved?

1047

How are functions and procedures called in PL/SQL?

1227

What is difference between rank () row_number () and dense_rank () in sql?

1101

What is sqlca in powerbuilder?

1014

What does stand for in sql?

966

How exception is different from error?

1016

What is a sql driver?

995

What is the difference between the implicit and explicit cursors?

1049

Is ms sql traffic encrypted?

922

What are pl sql procedures?

1024

What is minus?

989

what is the difference between char and varchar data types? : Sql dba

1109

How to fetch alternate records from a table?

1241