8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for LISTAGG DISTINCT in Oracle Database 19c


GlenM said...

I think the ROW_NUMBER() pre-19c solution needs to be partitioned by deptno,ename instead of just ename. If your test data added a Miller to another department I expect your result would only show Miller working in one department.

Cheers
Glen

Tim... said...

Hi.

Correct. Funny that a goofed on that, but did is correctly on the following example with distinct. Thanks for the headsup. :)

Cheers

Tim...

Rich said...

Tim,

The link to this page from this page (https://oracle-base.com/articles/19c/articles-19c) reads: "LISTAGG DISTINCT in Oracle Database 19c - Oracle 19c includes the ability to remove duplicates from the LISTAGG results by including the DEFAULT keyword."

I think you wanted to say DISTINCT there.

You don't allow comments on the source page.

Rich

Tim... said...

Hi.

Thanks for the heads-up. That typo is fixed in the article and in the link page.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.