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
How to export data to a csv file?
Does oracle database need java?
How to revoke create session privilege from a user in oracle?
What is a cursor and what are the steps need to be taken?
What happens if recursive calls get out of control?
How do I recompile a procedure in oracle?
How to create a new table in your schema?
What are group functions in oracle?
how to join query for one source type is oracle another source type is sql server ?
How does one get the view definition of fixed views/tables?
How to change user password in oracle?
What is program global area (pga) in oracle?
Why is oracle used?
Explain oracle 12c new features for developers?
Name the three major set of files on disk that compose a database in Oracle?