ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?
- 4 Answers
- 7134 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
How to get a list of all user accounts in the database?
Explain user account with reference to oracle.
What is oracle latest version?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a parameter file in oracle?
What happens if you lost a data file?
When system tablespace is created?
What is enter substitution variable in oracle?
How to retrieve data from an explicit cursor?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to create an oracle testing table?
How to create a single index for multiple columns?
What is the difference between Delete, Truncate and Drop in Oracle?
Can I create users through internet explorer in oracle 10g?
How to sort the query output in oracle?
