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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / manoj

Answer Posted / manoj

select level from dual connect by level<=10

Is This Answer Correct ?    113 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to use transactions efficiently : transact sql

921

Is sql easier than java?

944

Is it possible to include an insert statement on the same table to which the trigger is assigned?

955

Does inner join remove duplicates?

884

What is cursor and why it is required?

1105

What is the limitation on the block size of pl/sql?

935

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1069

Name three sql operations that perform a sort.

957

what are the difference between clustered and a non-clustered index? : Sql dba

976

How do I view tables in sql developer?

881

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..

2447

What is nosql db?

923

What are different types of indexes?

957

What are local and global Indexes and where they are useful.

1377

Can you have more than one key in a database?

890