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
State the various uses of dbcc command?
How to create lov dynamically at runtime & attach to text field?
How does the on-delete-cascade statement work?
How to store pictures on to the database?
Describe the types of sub query?
Explain about integrity constraint?
What is difference between sid and service name in oracle?
How many types of tables are there in oracle?
How to delete a user account in oracle?
How to use subqueries in the from clause in oracle?
How can I create database in oracle?
Explain database link?
What are the numeric comparison operations?
How can I introduce multiple conditions in like operator?
What is an index associated with a constraint?