oracle常用sql

1. 查询 判断非空 和 空字符串

 select  count(*) as total from act_yunifangmm_result where  trim(exchange_num) is not null ;

2. 创建索引

create yunifangmm_openid_idx on act_yunifangmm_result(openid);  -- 普通索引

create unique index "yunifangmm_openid_idx" on "act_yunifangmm_result" ("openid" asc);  -- 唯一索引