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

What is a constraint? Tell me about its various levels.

640

What is sql in java?

549

How to change sql*plus system settings?

545

What is auto increment in sql?

589

Why is stored procedure faster than query?

496

Is it possible to link two groups inside a cross products after the cross products group has been created?

598

What is view explain with example?

522

What is synchronized subquery?

600

explain normalization concept? : Sql dba

592

What is the primary key?

538

What is clustered index sql?

507

Explain foreign key in sql?

625

What is constant in pl sql?

519

How subquery works in sql?

545

What is tuple in sql?

547