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 hot backup vs. Cold backup?
What is SQL access advisor in Oracle?
How to define an external table with a text file?
How to view the data files in the current database?
How to connect to the server with user account: sys?
What is the fastest query method to fetch data from the table?
What is bind variable in oracle 11g?
what are actual and formal parameters?
How to use null as conditions in oracle?
Describe an oracle table?
What are the different types of failures that occur in Oracle database?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
what is IDE,DMV in sql server?
What is proxy method?
How do we represent comments in oracle?