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

how to produce numbers from 1 to 10 using dual table

Answer Posted / nihar ranjan nath

SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Will you be able to store pictures in the database?explain.

992


How view is different from a table?

1032


how to do daily transactions with out sql* loader control file regesterd in apps?

1685


What is set operator oracle?

975


How to drop a stored function?

1137


How to delete a column in an existing table in oracle?

1071


What is columnar storage what is the advantage?

1059


How to manage transaction isolation level?

1002


What are the attributes of the cursor?

1000


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840


How to commit the current transaction in oracle?

1118


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2129


How to delete a user account in oracle?

964


How to update values in a table in oracle?

1026


How is it different from a normal table?

1030