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

Point out the difference between user tables and data dictionary?

755


Explain a private synonyms?

820


What is oracle host variable?

710


What types of joins are used in writing subqueries?

740


How to start instance with a minimal initialization parameter file?

784


How to create additional tablespaces for an new database?

781


What are the major difference between truncate and delete?

733


Explain what are the advantages of views?

812


Explain an index segment?

837


How do I connect to oracle database?

740


Name the various constraints used in oracle?

795


Give syntax for SQL and ORACLE joins.

853


Can you tell me how to add new column in existing views?how?How is possible?

1131


How to write a query with a left outer join in oracle?

821


How oracle handles dead locks?

808