select wm_concat(rel) from UPDATE

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

Question Posted / ajit

Answer Posted / ajit

select wm_concat(rel)
from UPDATE_TEST

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the data type of dual table?

1001

Explain an exception?

1005

Can group functions be used in the order by clause in oracle?

999

Is the After report trigger fired if the report execution fails ?

2920

how to clone 9i Database on to 10g Database.

2346

What is null value in oracle?

1100

Will you be able to store pictures in the database?explain.

1000

What is the difference between PFILE and SPFILE in Oracle?

1068

When do I need to use a semicolon vs a slash in oracle sql?

1094

How to convert dates to characters in oracle?

1048

What is blob datatype?

1134

Why does Oracle not permit the use of PCTUSED with indexes?

2428

In oracle there is column command, how will you explain that?

1066

How to create a stored procedure in oracle?

1110

What are joins, explain all types of joins?

2300