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
- 8034 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 are the different types of trigger and explain its various uses and functions?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the differences between lov and list item?
What is memory advisor in Oracle?
How to assign a tablespace to a users in oracle?
What are the differences between number and binary_float in oracle?
What is where clause in oracle?
What is the dynamic sql in oracle?
How many types of database triggers exist?
How does oracle handle read consistency?
Explain the features of oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to use "if" statements on multiple conditions?
what is a Nested Loop join?
How to grant create session privilege to a user in oracle?
