test.sql

电信用户自服务系统

/**************************************/

select * from lhy_netctoss_user

select * from lhy_netctoss_user_service

/**************************************/

select * from lhy_netctoss_t_pricing

/**************************************/

select * from lhy_netctoss_t_admin

select * from lhy_netctoss_t_module

select * from lhy_netctoss_t_adm_rights

/**************************************/

select * from lhy_at_year_month_2008_8

select lab_ip,time_duration from lhy_at_year_2008 where to_char(trunc(logout_date,'month')) = '2008 08'

select * from lhy_at_year_2008

select * from lhy_rt_year_2008

select * from lhy_rt_detail_2008_8_8

select * from lhy_rt_detail_2008_8_10

delete from lhy_at_year_2008

insert into t_day values(to_date('1'), '192.168.1.20', 123);
insert into t_day values(sysdate, '192.168.1.20', 123);
select logout_date from t_day;
select to_date('2008-01-22 12:00:00', 'yyyy-mm-dd hh24:mi:ss') from dual;
select to_char(, 'yyyy-mm-dd hh24:mi:ss') from ;
select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual;