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 offset and limit in sql?

999

Are stored procedures faster than dynamic sql?

980

What is pivot table in sql?

1018

Name the operator which is used in the query for pattern matching?

892

Can we connect to postgresql using sql developer?

935

What packages are available to pl/sql developers?

992

what is difference between delete and truncate commands? : Sql dba

1065

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

970

What is sql entity?

1030

Which constraints we can use while creating database in sql?

1015

What is the difference between microsoft sql and mysql?

920

What is difference between nchar and nvarchar?

956

What is sql in oracle?

1002

What is sql*plus?

1017

Name three sql operations that perform a sort.

958