![]() The examples in this article require the following table.Įmpno NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY, ROW_NUMBER() and SYS_CONNECT_BY_PATH functions in Oracle 9i.WM_CONCAT Built-in Function (Not Supported).LISTAGG Analytic Function in 11g Release 2. ![]() This article is based on a thread from and contains several methods to achieve the desired results. Below is a list of the base data and the type of output we would like to return from an aggregate query. Using the SCOTT.EMP table as an example, we might want to retrieve a list of employees for each department. On occasion it is necessary to aggregate data from a number of rows into a single row, giving a list of data associated with a specific value. Home » Articles » Misc » Here String Aggregation Techniques
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |