SQL> select * 2 from xmltable('for $i in 1 to 10 return $i'

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

Question Posted / gangadhar

Answer Posted / gangadhar

SQL> select *
2 from xmltable('for $i in 1 to 10 return $i');

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is the primary key an index?

1026

what are the features and advantages of object-oriented programming? : Sql dba

1012

What is the non-clustered index in sql?

1064

what are the differences between char and nchar? : Sql dba

1115

What is sqlerrm?

941

Why primary key is required?

1010

How do I add a primary key to a table?

1042

What is the best partition size for windows 10?

1003

Name some usages of database trigger?

1021

What are literals in sql server?

1173

What is the clause we need to add in function body to return variable?

1012

Is sql better than excel?

1157

What are different types of triggers?

1114

Does group by remove duplicates?

1046

what is a control file ? : Sql dba

1045