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 ?
- 4 Answers
- 7908 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
What is a Garbage Collection? and what is full recursive Garbage collection?
How to convert characters to numbers in oracle?
Explain oracle instance.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to create id with auto_increment on oracle?
Explain oracle insert into command?
How to retrieve the count of updated rows?
What is backup in Oracle?
Explain about functional dependency and its relation with table design?
State and explain about oracle instance?
What is oracle datasource?
Explain integrity constraints?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to write a query with a left outer join in oracle?
Explain the use of consistent option in exp command.
