Oracle常用查询语句

1、查找某列存在重复的 数据

SELECT t.code,COUNT(*) FROM T_BSM_BOXBAG t WHERE t.deleted = 'N' GROUP BY t.code HAVING COUNT(*) > 1

2、查找某列长度大于10的数据

SELECT * from  T_BSM_BOXBAG t where length(t.code) > 10

3、查询数据库编码

select userenv('language') from dual;

4、时间统计数据

   //按天统计  
    select count(dataid) as 每天操作数量, sum()  
    from  
    where  
    group by trunc(createtime, 'DD'))  
   //按自然周统计   
   select to_char(date,'iw'),sum()   
    from   
    where   
    group by to_char(date,'iw')   
   //按自然月统计   
   select to_char(date,'mm'),sum()   
   from   
   where   
   group by to_char(date,'mm')   
   //按季统计   
   select to_char(date,'q'),sum()   
   from   
    where   
   group by to_char(date,'q')   
  //按年统计   
  select to_char(date,'yyyy'),sum()   
  from   
  where   
  group by to_char(date,'yyyy')