May 2012

Turning rows into a string using LISTAGG

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 →

State Contracts

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 →

PIVOT using two columns

One of the new features in 11g is PIVOT. I was reading this excellent writeup recently and saw that PIVOT could work with multiple columns, so it came to mind when a developer mentioned needing a query that would take up to the 3 newest phone numbers from the phone number table and convert them […]

Read more →

Oracle’s Direct Path Loads in ODP.NET

By Nicholas Geiger and Granville Bonyata Long time Oracle users will know that SQL*Loader and external tables are a great way to quickly load large files into tables using Oracle’s Direct Path Load. But for .NET shops, there may be a lot of security tied to the IIS servers that would be circumvented by copying […]

Read more →