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

How to change program global area (pga) in oracle?

1084

How to drop a stored procedure in oracle?

1051

When do you get a .pll extension in oracle?

1144

How will you identify oracle database software release?

1005

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1930

How to write date and time literals in oracle?

1000

How to get execution statistics reports on query statements?

1086

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1349

How to use regular expression in pattern match conditions in oracle?

1037

How to display employee records who gets more salary than the average salary in the department?

1065

What is a trigger and what are its types in oracle?

1068

Explain an integrity constrains?

1143

What privilege is needed for a user to create tables in oracle?

953

Whether any commands are used for months calculation? If so, what are they?

1095

How to assign values to data fields in record variables?

1031