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

How to export data to a csv file?

1317


Does oracle database need java?

1013


How to revoke create session privilege from a user in oracle?

1026


What is a cursor and what are the steps need to be taken?

1213


What happens if recursive calls get out of control?

1088


How do I recompile a procedure in oracle?

974


How to create a new table in your schema?

1089


What are group functions in oracle?

1051


how to join query for one source type is oracle another source type is sql server ?

2433


How does one get the view definition of fixed views/tables?

1031


How to change user password in oracle?

1040


What is program global area (pga) in oracle?

1040


Why is oracle used?

947


Explain oracle 12c new features for developers?

1063


Name the three major set of files on disk that compose a database in Oracle?

1129