Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql query

Re: sql query

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Sep 2005 16:20:16 -0700
Message-ID: <1128122416.951019.36150@f14g2000cwb.googlegroups.com>


You can easily find the answer to this question by searching the newsgroup archives on the phrase "pivot table"

http://groups.google.com/group/comp.databases.oracle.server/browse_frm/thread/232ba4b0028bd1f5/cdee1d79caf2c73a?lnk=st&q=%22pivot+table%22+group:comp.databases.oracle.*&rnum=5&hl=en#cdee1d79caf2c73a

If this example isn't clear I can repost with an example: create pivot table, insert pivot data, and use in join to source table.

You can also find approaches to this problem on the asktom website: http://asktom.oracle.com

HTH -- Mark D Powell -- Received on Fri Sep 30 2005 - 18:20:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US