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
Difference between inner join vs where ?
Can group functions be used in the order by clause in oracle?
What is the fastest query method to fetch data from the table?
Describe the types of sub query?
What is dynamic proxy?
What are the differences between number and binary_float in oracle?
How do I reset a sequence in oracle?
How are extents allocated to a segment?
What is ordinary table in oracle?
What is pragma autonomous transaction in oracle?
Differentiate between translate and replace?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to pass parameters to procedures in oracle?
What are the types of partitions in oracle?
How to write a query with a left outer join in oracle?