📄 新建文本文档.txt
字号:
查询长途:
select phone_nbr,call_start_time,
end_phone_nbr,chg_duration,
basic_chg,tax,basic_chg+tax
from hrb_vw_ld_call_dtl@cxjd
where phone_nbr ='2345986'
and billing_period='200006'
and bill_item='LDC'
order by call_start_time
select phone_nbr,call_start_time,
end_phone_nbr,chg_duration,
basic_chg,tax,basic_chg+tax
from hrb_tb_ld_call_dtl_06@cxjd
where phone_nbr ='2345986'
and billing_period='200006'
and bill_item='LDC'
order by call_start_time
查询信息费:
select phone_nbr,call_start_time,
end_phone_nbr,chg_duration,
basic_chg,tax,basic_chg+tax
from hrb_vw_ld_call_dtl@cxjd
where phone_nbr ='2345986'
and billing_period='200006'
and bill_item='INFO'
order by call_start_time
查询话费汇总:
select * from hrb_tb_jf_chgit_query@cxjd
where phone_nbr ='2345986'
and billing_period ='200006'
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -