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

What are the differences between lov and list item?

992

Explain the dml?

921

How to create a new table by selecting rows from another table?

1019

Explain the difference between sap and oracle?

975

What are the numeric comparison operations?

1056

How much memory your 10g xe server is using?

1051

How to call a sub procedure?

1036

How to install oracle odbc drivers?

1040

How to start instance with a minimal initialization parameter file?

992

How to find the duplicate rows count from employees table in oracle?

1041

How data locks are respected in oracle?

1013

What is literal?

956

what is the difference between substr and instr function in oracle?

1036

Is java required for oracle client?

928

How to delete a column in an existing table in oracle?

1011