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

Answer Posted / pushkar

use sequence. automatically increments.

Is This Answer Correct ?    10 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2200


Which is faster union or join?

712


What are character functions?

815


How do I count rows in sql?

755


how many columns can be used for creating index? : Sql dba

689


Can you have a foreign key without a primary key?

691


What does the hierarchical profiler does?

769


How can I tell if sql is running?

777


what is a trigger? : Sql dba

771


Are there any features that are decommissioned in 11g that are not present in 11g?

1841


How can triggers be used for the table auditing?

769


What are the different types of triggers?

798


What is trigger types in sql?

735


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

875


difference between anonymous blocks and sub-programs.

838