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

Explain the the delete statements in sql?

577

Why plvtab is considered as the easiest way to access the pl/sql table?

617

How can we debug in PL/SQL?

655

what is bcp? When is it used?

578

what are the differences among rownum, rank and dense_rank? : Sql dba

538

Explain the the update statement in sql?

570

Explain about various levels of constraint.

521

What are sql commands?

502

Does normalization improve performance?

552

What is partition by in sql?

569

Does sql backup shrink transaction log?

551

Can a table have no primary key?

551

what is the difference between join and union? : Sql dba

545

Why truncate is faster than delete?

560

Show how functions and procedures are called in a pl/sql block.

586