select level from dual connect by level <=10;

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

Question Posted / pramod kumar behera

18 Answers
47536 Views
HCL, Nyros, Oracle, I also Faced
E-Mail Answers

Answer Posted / pramod kumar behera

select level from dual connect by level <=10;

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the different type of joins?

1057

How do you declare a constant?

953

Explain the difference between 'between' & 'and' operators in sql

990

How are functions and procedures called in PL/SQL?

1209

What are the basic techniques of indexing?

1056

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2012

Can we use loop in sql?

964

Why truncate is faster than delete?

1100

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

1095

how to include numeric values in sql statements? : Sql dba

1091

How do I find duplicates in the same column?

1074

How to execute a stored procedure?

1075

What is a dynamic query?

1016

Why do we use function in pl sql?

1052

What does joining a thread mean?

1013