ex. one table is having 1 column with 10 records ,
then how to display all the values in row wise ?

Answer Posted / ajit

select wm_concat(rel)
from UPDATE_TEST

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does sharding mean?

527


Is a rollback possible to any savepoint?

550


Why do we use bulk collect in oracle?

554


Oracle

1833


What is the string concatenation operator in oracle?

558






How to pass a cursor variable to a procedure?

544


What is an oracle function?

583


What are temporal data types in oracle?

586


What is not equal to in oracle?

513


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1728


What happens to indexes if you drop a table?

679


What is an oracle and why it is used?

609


Why do we use coalesce function in oracle?

614


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

612


How to open and close an explicit cursor in oracle?

560