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 / rashmi raju

select 1,2,3,4,5,6,7,8,9,10 from dual;

Is This Answer Correct ?    3 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is trigger a stored procedure?

938


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1216


What is the difference between numeric and autonumber?

1004


What are all the different types of indexes?

1152


Explain the difference in execution of triggers and stored procedures?

1024


Is sql better than excel?

1160


what is a materialized view? : Sql dba

1068


How does sql*loader handles newline characters in a record? : aql loader

1051


How to Execute a Package in PL/SQL.?

1212


what is a cursor? : Sql dba

1029


What sql does db2 use?

986


What is dynamic sql in pl sql?

1040


What are all the ddl commands?

1187


Is inner join same as self join?

1122


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2449