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

Is sql a scripting language?

1004

Can we create table in function?

964

Is microsoft sql free?

1100

Can we call a function containing dml statements in a select query?

974

explain primary keys and auto increment fields in mysql : sql dba

977

What is sql*plus?

1075

define sql update statement ? : Sql dba

1117

What does fetching a cursor do?

1085

What is varchar example?

1029

Which language is used in sql?

1057

Why coalesce is used in sql?

1008

What is embedded sql with example?

1047

How do I run a program in pl sql?

1002

How many parts of a pl sql block are optional?

1131

What is anonymous block in sql?

1120