«  
  »

Oracle Database 11g: BI and Data Warehousing Student Guide

作者: Maclean Liu , post on October 7th, 2010 , English Version
【本站文章除注明转载外，均为本站原创编译】
转载请注明：文章转载自: Oracle Clinic – Maclean Liu的个人技术博客 [http://www.oracledatabase12g.com/]
本文标题: Oracle Database 11g: BI and Data Warehousing Student Guide
本文永久地址: http://www.oracledatabase12g.com/archives/oracle-database-11g-bi-and-data-warehousing-student-guide.html

Summary

In this lesson, you should have learned how to:

  • Identify the benefits of pivoting and unpivoting operations
  • Write crosstab queries to pivot (rotate) column values into new columns and to unpivot (rotate) columns into column values
  • Pivot and unpivot with multiple columns and multiple aggregates
  • Use wildcards and aliases with pivoting operations


© 2010 – 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

  1. Dumps,Crashes and Corruptions Student Guide
  2. Oracle DUL(Data Unloader) User Guide and Downloads
  3. Oracle Data Integrator 11g Product Overview and New Features
  4. Oracle Database 11g Transparent Data Encryption
  5. Step By Step guide for installing Oracle RAC 11gR2 on AIX
  6. Performance Tuning Guide for Siebel CRM Application on Oracle
  7. ACFS Technical Overview and Deployment Guide
  8. How to view and edit data on ASM using BBED
Oracle, Oracle数据仓库Data Warehouse   , , ,  
«  
  »

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

«  
  »