行列转换

By on 2009/02/03 at 12:00 上午 in Oracle RDBMS
     最近好多地方要用到行列转换,在平常的转换中我一般都利用case,decode,max等的聚集函数或者他们之间的组合来实现.不过又看到了好多大师的个人杰作。以备学习
    http://asktom.oracle.com/pls/asktom/f?p=100:11:293731689770601::::P11_QUESTION_ID:124812348063
    http://asktom.oracle.com/pls/asktom/f?p=100:11:293731689770601::::P11_QUESTION_ID:124812348063
    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2196162600402
    http://www.ningoo.net/html/2008/how_to_do_string_aggregate_on_oracle.html(Ningoo介绍了使用sys_connect_by_path函数和wmsys.wm_concat函数的转换方法)
 

Relative Posts

Tags:

Leave a Reply