orcale sql常用语句

1. case .. when .. then .. end Oracle CASE WHEN 用法介绍

select nvl(sum(case p.need_mistake_audit_level
                 when 1 then
                  (case
                    when mis.audit_status in (-1, 0) then
                     1
                    else
                     0
                  end)
                 when 2 then
                  (case
                    when mis.audit_status in (-1, 0) or
                         (mis.audit_status in (1) and mis.audit_status2 in (0, 3)) then
                     1
                    else
                     0
                  end)
                 else
                  0
               end),
           0) status
  from base_mistake mis
  left join permission_sgdac p
    on mis.sec_id = p.id
 where mis.data_table = 'XXX'
   and mis.data_column = 'OOO'
   and mis.data_id = '8612bada1581445796a8f644d65c7968';

 2.  Ruthless的 oracle 博文

oracle初级系列教程

oracle中级系列教程

oracle高级系列教程

oracle分析函数

3. 账户相关操作

查询数据库账户信息：select a.username, a.password, a.lock_date, a.account_status from dba_users a;

给指定用户解锁：ALTER USER scott ACCOUNT UNLOCK;

使用ALTER USER语句为scott账户设置口令：ALTER USER scott IDENTIFIED BY tiger;

 Oracle查询用户所有表