Oracle SQL精妙SQL语句讲解

　　--行列转换 行转列　　DROP TABLE t_change_lc;　　CREATE TABLE t_change_lc (card_code VARCHAR2(3), q NUMBER, bal NUMBER);　　INSERT INTO t_change_lc　　SELECT '001' card_code, ROWNUM q, trunc(dbms_random.VALUE * 100) bal FROM dual CONNECT BY R