it will need a cursor. begin for cur1 in (select a from Name) loop dbm

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

Question Posted / ruchi varma

4 Answers
7851 Views
I also Faced
E-Mail Answers

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

What is MTTR advisor in Oracle?

1075

Explain the characteristics of oracle dba?

1101

List the types of joins used in writing subqueries?

980

definition of cluster and non-clustered index?

3008

What is execute immediate in oracle?

993

How to synchronize 2 schema's objects?

2147

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2194

How to create a new user account in oracle?

991

How to export several tables together?

1030

What is merge in oracle?

1033

How do I uninstall oracle client from windows?

1000

List out the components of logical database structure of oracle database.

1009

Can we store images in oracle database?

986

Is oracle an open source?

1058

What happens to the indexes if a table is recovered?

971