oracle基知识培训.pptVIP

ORACLE常见函数-substr substr(dest_terminal_id,3,7)截取字符串 --首层 select to_char(send_time,yyyymmdd),city, count(distinct sender) 首层转发人数 ,count(*) 首层转发条数 from t_p_sms_transmit_detail a ,t_p_mobile_config b WHERE sender in (select mobile_num from t_p_user where user_type=1) and send_time=to_dateyyyymmdd) and send_time=to_dateyyyymmdd) and substr(a.sender,1,7)=b.mobile group by to_char(send_time,yyyymmdd),city order by 1,2 ORACLE常见函数-length() Length函数，在处理黑名单表是比较常用，由于T_P_BLACKLIST表的phone字段为varchar类型，因此我们经常会录入一些其他字符，导致在SELECT mobile_num FROM t_p_user WHERE mobile_num NOT IN (SELECT