I have a complex and sucessful query that that uses LISTAGG to show codes associated to a parent list.
My question is: can I use LISTAGG to produce and output a column with a specific number of delimiters. I need to import this file into Excel for further processing, but the LISTAGG column needs 39 delimiters to process into 40 columns when imported into Excel regardless of the number of results.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.