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

How many types of auditing in Oracle?

571


What is a cursor in oracle?

652


What are the different pseudo commands? Explain in general?

544


How to get a create statement for an existing table?

574


What is the difference between a hot backup and a cold backup in oracle?

579






Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1515


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1851


What is a private synonym?

1088


What are the different types of partitions in oracle?

501


Can a formula column referred to columns in higher group ?

2089


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3705


In the oracle version 9.3.0.5.0, what does each number shows?

753


Explain oracle 12c new features for developers?

541


How to create a table index?

569


Why use resource manager in Oracle?

666