oracle
nisd2017
这个作者很懒,什么都没留下…
展开
-
oracle 10g表分区
Select Segment_Name,segment_type,Sum(bytes)/1024/1024 sizeName_M From User_Extents Group By Segment_Name,segment_type order by sizeName_M descselect * from user_operation_log_pSelect Count(1) From...原创 2016-12-01 14:18:04 · 143 阅读 · 0 评论 -
常用oracle操作语句
CREATE TABLESPACE dcip DATAFILE 'F:\tablespaceswin7\dcip.ora' SIZE 50M AUTOEXTEND ON NEXT 10M;drop user dcip cascade;create user dcip identified by dcip default tablespace dcip;grant connect,r...原创 2017-02-16 15:42:28 · 88 阅读 · 0 评论 -
经典sql记录
1、聚合函数行转列:select name,sum(case when subName='语文' then grade else 0 end) 语文,sum(case when subName='数学' then grade else 0 end) 数学,sum(case when subName='英语' then grade else 0 end) 英语from t_user ...原创 2017-02-16 15:51:59 · 105 阅读 · 0 评论