Transpose Table Scripts

From: <info_at_revealnet.com>
Date: Mon, 05 Oct 1998 15:18:06 GMT
Message-ID: <6vanve$p0m$1@nnrp1.dejanews.com>

2 new scripts have just been aded to the PL/SQL Pipeline. The PL/SQL pipeline is a free community for Oracle developers worldwide. The pipelines have over 8,000 registered members, and includes discussion groups, technical papers, free utilities and more. The PL/SQL Pipeline is hosted by best-selling author Steven Feuerstein and sponsored by RevealNet. http://www.revealnet.com/pipeline.htm

----------------------------------------------------------------- Transpose

Table Information By Steven Feuerstein and Solomon Yakobson

This month's archive features a useful procedure that arose from a thread on the PL/SQL Pipeline's Pipetalk bulletin board. A Pipeliner needed to transpose the rows and columns of a table into a different table. After a few back and forths from a number of people, the ever-present and ever-helpful Solomon Yakobson provided a generic solution using dynamic SQL (the DBMS_SQL) package. Steven Feuerstein took his version and "spruced it up" a bit by creating a stand-alone function that will calculate the number of rows in any table (might as well offer as many handy utilities as possible!). The archived zip contains the scripts to create the two procedures (transpose.sp), as well as a test script to demonstrate the core procedure's capability (transpose.tst). Enjoy!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 05 1998 - 10:18:06 CDT