Custom aggregate function inside a package does not work??
LISTAGG Analytic Function in 11g Release 2
SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees
FROM emp
GROUP BY deptno;
WM_CONCAT Built-in Function (Not Supported)
SELECT deptno, wm_concat(ename) AS employees
FROM emp
GROUP BY deptno;
User-Defined Aggregate Function
Specific Function
Generic Function using Ref Cursor
ROW_NUMBER() and SYS_CONNECT_BY_PATH functions in Oracle 9i
COLLECT function in Oracle 10g
https://oracle-base.com/articles/misc/string-aggregation-techniques
http://www.oracle.com/technetwork/issue-archive/2006/06-jul/o46sql-083623.html
Wednesday, October 24, 2018
Valuable Developer Tools
These is the list of tools that we spoke about that I think would be very valuable to us to ensure we deliver very high quality of code:
- .NET Memory Profiler. Leading tool to optimize memory usage and find memory leaks in any .NET application. This tool is used internally by Microsoft to analyze memory in .NET applications and .NET itself.
- JetBrains dotTrace Performance. Leading profiling tool to optimize .NET applications and detect performance bottlenecks. This tool is very lightweight and very fast to run and produces very accurate results.
- .NET Reflector. A must have tool for .NET development to understand .NET Framework and debug any .NET code. Although there’s very good free alternative ILSpy which has almost the same features.
- Redgate ANTS Performance Profiler. Another good and feature rich performance profiling tool however a bit heavy and requires very good hardware to perform performance tests.
- SQLSolutions & SQL Power Tools. Good tools to analyze and detect performance problems in your SQL Server.
- .NET Memory Profiler. Leading tool to optimize memory usage and find memory leaks in any .NET application. This tool is used internally by Microsoft to analyze memory in .NET applications and .NET itself.
- JetBrains dotTrace Performance. Leading profiling tool to optimize .NET applications and detect performance bottlenecks. This tool is very lightweight and very fast to run and produces very accurate results.
- .NET Reflector. A must have tool for .NET development to understand .NET Framework and debug any .NET code. Although there’s very good free alternative ILSpy which has almost the same features.
- Redgate ANTS Performance Profiler. Another good and feature rich performance profiling tool however a bit heavy and requires very good hardware to perform performance tests.
- SQLSolutions & SQL Power Tools. Good tools to analyze and detect performance problems in your SQL Server.
Subscribe to:
Comments (Atom)