use sequence. automatically increments.

i want to display 1 to 10 numbers using one select statement.

Question Posted / pushkar

Answer Posted / pushkar

Is This Answer Correct ?

10 Yes

27 No

Please Help Members By Posting Answers For Below Questions

Mention what is the function that is used to transfer a pl/sql table log to a database table?

484

What is sql profiler in oracle?

560

what is index? : Sql dba

558

Why query optimization is needed?

517

What is the difference between distinct and unique in sql?

471

explain the delete statements in sql

578

Can one improve the performance of sql*loader? : aql loader

585

what is heap table? : Sql dba

607

What are the different set operators available in sql?

563

What is the difference between delete, truncate and drop command?

547

How is a PL/SQL code compiled?

667

Can we create clustered index without primary key?

521

Differentiate pl/sql and sql?

561

What are the different types of triggers?

591

What are the events on which a database trigger can be based?

594