With 11gR2, we get one of the cooler analytic functions yet – LISTAGG, which allows you to turn rows into a single string. LISTAGG relies on the “GROUP BY” engine, so it’s efficient and easy to code: SELECT name, listagg(phonenumber,’, ‘) WITHIN GROUP (ORDER BY phonenumber) Numbers FROM phone GROUP BY name / Name Numbers Bob […]
Read more →
KMC Data has performed over $1 million in state contract work over the last 5 years as a subcontractor, including several large billing/permitting systems for Florida Dept of Agriculture (DOACS) and Florida Fish and Wildlife Conservation Commission (FWC). Licensing and billing system for all commercial salt water licenses in Florida for FWC, in .NET/C# and […]
Read more →