Oracle: Combine multiple results in a subquery into a single comma-separated value

sql oracle subquery string-aggregation
Jason Cohen picture Jason Cohen · Jan 29, 2009 · Viewed 36.4k times · Source

I'm trying to convert a single-columned subquery into a command-separated VARCHAR-typed list of values.

This is identical to this question, but for Oracle rather than SQL Server or MySQL.

Answer

Justin Cave picture Justin Cave · Jan 29, 2009

There is an excellent summary of the available string aggregation techniques on Tim Hall's site.

Related questions

comma-separated list as a result of select statement in Oracle

I have a table named "person". It contains person's id and it's parent id (only one parent is possible). As a result of a query, I want a table with first column - a person id, and a second column …

Read More
subquery in FROM must have an alias

I have this query I have written in PostgreSQL that returns an error saying: [Err] ERROR: LINE 3: FROM (SELECT DISTINCT (identifiant) AS made_only_recharge This is the whole query: SELECT COUNT (made_only_recharge) AS made_only_recharge FROM ( …

Read More
Find duplicate entries in a column

I am writing this query to find duplicate CTN Records in table1. So my thinking is if the CTN_NO appears more than twice or higher , I want it shown in my SELECT * statement output on top. I tried the …

Read More