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 difference between sql and oracle?

1066

What does trigger mean in slang?

1018

What is file based approach?

892

What are the different dcl commands in sql?

1086

What is trigger price?

935

When to use inner join and left join?

921

Does pl sql work in mysql?

937

Are stored procedures faster than queries?

911

What is forward declaration in pl sql?

1021

What is sql injection vulnerability?

884

What is a primary key sql?

1010

What does fetching a cursor do?

1036

What is Histogram?

1516

What is normalization in sql?

974

where are cookies actually stored on the hard disk? : Sql dba

991