ITPub博客

首页 > Linux操作系统 > Linux操作系统 > hehe

hehe

原创 Linux操作系统 作者:nolpwd 时间:2011-05-31 00:44:51 0 删除 编辑
-----------------------------------
create table testflow
(
userid number,
flowup number,
flowdown number
)
insert into testflow values (1,1,2);
insert into testflow values (1,1,2);
insert into testflow values (1,1,2);
insert into testflow values (1,1,2);
insert into testflow values (1,1,2);
insert into testflow values (2,4,2);
insert into testflow values (2,4,2);
insert into testflow values (2,4,2);
insert into testflow values (2,4,2);
insert into testflow values (2,4,2);
insert into testflow values (3,3,2);
insert into testflow values (3,3,2);
insert into testflow values (3,3,2);
insert into testflow values (3,3,2);
insert into testflow values (3,3,2);
commit
insert into testflow values (3,3,2);
commit
select count(*) from testflow;
create table userinfo
(
userid number,
userinfo char(20)
)
insert into userinfo values(1,'qqq');
insert into userinfo values(2,'www');
insert into userinfo values(3,'eee');
commit
create table useraccount1
(
username char(20)
)
insert into useraccount1 values('qqq');
insert into useraccount1 values('eee');
commit
create table userid
(
userid number
)
insert into userid (userid)
select u.userid from userinfo u,useraccount1 ua where u.userinfo=ua.username;
commit
select * from userid
commit
select sum(fl.flowup+fl.flowdown) from testflow fl,userinfo u where fl.userid=u.userid and u.userid in (1,2,3,1)
select sum(fl.flowup+fl.flowdown) from testflow fl,userinfo u where fl.userid=u.userid and u.userid in (select userid from userid)

select
drop table "GCY1"."USER_LOAD"
CREATE TABLE "GCY1"."USER_LOAD"
   ( "USERID" NUMBER NOT NULL ENABLE,
 "CHARTITO" NVARCHAR2(30),
 "TIMEBEGIN" NVARCHAR2(30),
 "TIMEEND" NVARCHAR2(30)
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
select count(*) from "GCY1"."USER_LOAD"
exp gcy1/gcy1 tables=sys.testflow,sys.userinfo,sys.useraccount1,USER_LOAD file=gcy1.dmp
create user gcy3 identified by gcy3
grant sysdba,CREATE SESSION to gcy3
imp gcy1/gcy1 fromuser=gcy1 touser=gcy3 file=gcy1.dmp full=y
imp gcy1/gcy1 fromuser=gcy1 touser=gcy3 file=gcy1.dmp
testflow,userinfo,useraccount1,USER_LOAD
select * from user_tables
sqlldr userid=gcy1/gcy1 control=user_load.ctl
   load data          
   infile 'TITO_PCRF_26-05-2011_0315AM.txt'   
   insert into table USER_LOAD    
   fields terminated by ","    
   (USERID,CHARTITO,TIMEBEGIN,TIMEEND) 
select sum(up+down) from user_flow u,

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25243263/viewspace-696727/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 大话rac
请登录后发表评论 登录
全部评论

注册时间:2011-05-25

  • 博文量
    44
  • 访问量
    72025