ANY Types, Pipelined Table Functions, Dynamic SQL and Pivot

Amazing what you can do with ANYTYPE, ANYDATA, ANYDATASET, DBMS_TYPES, DBMS_SQL and pipelined table functions implemented using the interface approach. You can end up with a dynamic sql mashup like you’ve never seen before, and pivot like you’ve never pivoted before. Of course, if you’re on Oracle DB 10g or below, you can never pivot like this.

Filed in Oracle with 1 Comment | Tags: datatype, dynamic, pipelined, pivot, sql

---