Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / pramod kumar behera

select rownum from dual connect by level <=10;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to get help information from the server? : Sql dba

893


What is sql architecture?

1005


What are the subsets of sql?

1071


How do I save a stored procedure?

961


What is trigger and types?

982


Can you select everything, but 1 or 2 fields, without writer's cramp?

955


what are ddl statements in mysql? : Sql dba

1133


what is the difference between char_length and length? : Sql dba

1005


what is sql in mysql? : Sql dba

1142


What is difference between function and trigger?

996


Is there a way to automate sql execution from the command-line, batch job or shell script?

937


How to download oracle sql developer?

1065


What is bind variable in pl sql?

997


What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2541


How do I send sql query results to excel?

1020