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
What is user managed backup in Oracle?
Explain drop constraint oracle?
How to use "while" statements in oracle?
What is Data Dictionary Cache in Oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to drop a tablespace?
how can we store any pdf file in oracle
What is the relation of a user account and a schema?
What is oracle server autotrace in oracle?
Why do we need integrity constraints in a database?
Can group functions be used in the order by clause in oracle?
What are transaction isolation levels supported by oracle?
How to drop an index in oracle?
What is redo log?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.