select level from dual connect by level

how to produce numbers from 1 to 10 using dual table

Question Posted / ml

Answer Posted / ml

select level from dual connect by level < 11;

Is This Answer Correct ?

26 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can group functions be used in the order by clause in oracle?

999

Which is better Oracle or MS SQL? Why?

4944

How to write date and time interval literals in oracle?

1036

How to use values from other tables in update statements using oracle?

1080

What is memory advisor in Oracle?

1077

What is an oracle tablespace?

1045

What happens to the current transaction if a ddl statement is executed?

1013

definition of cluster and non-clustered index?

3035

How will you write a query to get a 5th rank student from a table student_report?

1866

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

how to handle exceptions in post production

1426

What is where clause in oracle?

1031

How to drop a stored procedure in oracle?

1051

Difference between open_form and call_form in oracle.

1161

What is the difference between sharding and partitioning?

986