This content has been marked as final. Show 6 replies
Please read SQL and PL/SQL FAQ to provide proper information.
update target_table set tgt_column = (select listagg(col, ',') within group(order by col) col from table_name) where your_predicates
getting error using within clause
from keyword expected
the tab contains distinct remarks which needs to be updatedPlease read the FAQ
i dont want to hard code the values of resultAnd the manuals
Particularly SQL Language Reference
There is no point in asking questions until you have a chance of understanding the answers.