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

How many types of keys are there in sql?

557

what is the syntax used for partition in tsql? : Transact sql

542

Explain locks? : Transact sql

575

What does select top 1 do in sql?

544

What is dml with example?

519

How many aggregate functions are available there in sql?

529

how to include character strings in sql statements? : Sql dba

556

What is crud sql?

543

What are synonyms in sql?

536

what is a field in a database ? : Sql dba

547

What is dcl in sql?

528

what is transaction? : Sql dba

532

What are the two types of cursors in pl sql?

542

How do I count records in sql?

518

What do you know by pl/sql cursors?

571