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
How many types of auditing in Oracle?
What is a cursor in oracle?
What are the different pseudo commands? Explain in general?
How to get a create statement for an existing table?
What is the difference between a hot backup and a cold backup in oracle?
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?
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
What is a private synonym?
What are the different types of partitions in oracle?
Can a formula column referred to columns in higher group ?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
In the oracle version 9.3.0.5.0, what does each number shows?
Explain oracle 12c new features for developers?
How to create a table index?
Why use resource manager in Oracle?