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

Can we call a function containing dml statements in a select query?

1025

What types of commands can be executed in sql*plus?

1167

What is cascade in sql?

1017

Why do we need databases?

1093

What is an inconsistent dependency?

1087

What does pl sql developer do?

982

When is the update_statistics command used?

1182

What is procedure explain with example?

1009

what is the difference between myisam static and myisam dynamic? : Sql dba

1115

What is a sql schema used for?

1156

How do you optimize a stored procedure in sql?

1019

what is 'mysqladmin' in mysql? : Sql dba

1076

What is forward declaration in pl sql?

1141

How can you know that statistics should be updated?

1129

tell me about various levels of constraint. : Sql dba

1077