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

How can you view the errors encountered in a trigger?

956

Can a procedure in a package be overloaded?

1040

What are different types of statements supported by sql?

1159

What is auto increment feature in sql?

1117

What are the types of optimization?

946

Advantages and disadvantages of stored procedure?

1118

What is pls integer?

1026

How do I install microsoft sql?

1043

How do you identify a primary key?

1059

what is union? : Sql dba

1021

Is foreign key mandatory?

998

how to include numeric values in sql statements? : Sql dba

1097

Can we commit in trigger?

962

How do I make my sql query run faster?

938

What is the difference between sum and count in sql?

984