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

ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?

Answer Posted / ruchi varma

it will need a cursor.

begin
for cur1 in (select a from Name) loop
dbms_output.put(cur1.a);
end loop;
end;

dbms_output.put -> displays a chr without putting a new line

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the various uses of dbcc command?

989


How to create lov dynamically at runtime & attach to text field?

1097


How does the on-delete-cascade statement work?

1059


How to store pictures on to the database?

923


Describe the types of sub query?

938


Explain about integrity constraint?

1077


What is difference between sid and service name in oracle?

904


How many types of tables are there in oracle?

1004


How to delete a user account in oracle?

912


How to use subqueries in the from clause in oracle?

1043


How can I create database in oracle?

959


Explain database link?

1060


What are the numeric comparison operations?

1051


How can I introduce multiple conditions in like operator?

923


What is an index associated with a constraint?

973