本人在工程上收集的比较常用的oracle sql语句 有问题请发email:leafboyman@tom.com

				drop user dyt cascade;
				create user dyt identified by sql default tablespace users;
				grant dba to dyt;
				connect dyt/sql;
				
				create sequence userinfID start with 10000;
				create sequence operateuserID start with 10000;
				
				drop table msgstat;
				create table msgstat(
					stime 		date,
					msgid		number(8),
					send		number(8)
				);
				create index msgstat_stime_idx on msgstat(stime);
				
				create table history(
					stime 		date,
					msisdn		varchar2(20),
					vlr		number(10),
					hcity		number(3),
					vcity		number(3),
					condition 	number,
					errorCode	number(2)
				);
				create index history_idx on history(stime);
				create index history_msisdn_idx on history(msisdn);
				
				create table status(
				     	stime      date	primary key,
				     	bufmsgcount number(10),
				     	total      number(10),
				     	lost       number(10),
				     	Empty      number(10),
				     	sended     number(10),
				     	fail       number(10)
				);
				create index status_idx on status(stime);
				
				create table stat(
					stime 		date,
					city		number(4),
					vlrcity		number(4),
					visit 		number(12),
					send		number(12)
				);
				create index stat_idx on stat(stime);
				create index stat_city_idx on stat(city,vlrcity);
				
				quit;