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

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

Answer Posted / pramod kumar behera

select rownum from dual connect by level <=10;

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is oltp (online transaction processing)? : Sql dba

1016

What is nested table in pl sql?

1007

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976

Is sql free?

889

Explain the types of joins in sql?

966

The select into statement is most often used to create backup copies of tables or for archiving records?

1002

What is sql table?

904

What are triggers and its types?

996

what is a cursor? : Sql dba

972

What are three advantages to using sql?

961

tell me about various levels of constraint. : Sql dba

991

What does pragma mean?

975

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

1052

What are instead of triggers?

997

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1537