第35次：2014-10-15

botang

1.   SELECT /*+ NOREWRITE */ c.cust_last_name,
   
2.     c.cust_credit_limit,
   
3.     SUM(amount_sold) AS dollar_sales
   
4.   FROM sales s, customers c
   
5.   WHERE s.cust_id= c.cust_id
   
6.   GROUP BY c.cust_last_name,
   
7.     c.cust_credit_limit
   
8.   ORDER BY 1;
   
9.   
   
10.   select  * from dba_dimensions  d where d.owner='SH';
    
11. 
    
12. select  * from dba_dim_hierarchies   dh where dh.dimension_name='CUSTOMERS_DIM';
    
13. 
    
14. select  * from dba_dim_child_of  dco where dco.hierarchy_name='GEOG_ROLLUP';
    

复制代码