result.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

) TABLESPACE SYSTEM;                                                                                                                                                                                                                                           
ALTER TABLE CONDITION ADD CONSTRAINTS SYS_C003110 PRIMARY KEY(ID);                                                                                                                                                                                             

DROP TABLE CONFIG;                                                                                                                                                                                                                                            
-- 表名：CONFIG                                                                                                                                                                                                                                                
-- 备注：                                                                                                                                                                                                                                                      
CREATE TABLE CONFIG(                                                                                                                                                                                                                                           
	CREATE_TIME                    DATE,                                                                                                                                                                                                                          
	DELETE_TIME                    DATE,                                                                                                                                                                                                                          
	LOCATION_PROVINCE              NUMBER(3,0),                                                                                                                                                                                                                   
	MINSENDTIMESPAN                NUMBER(10,0),                                                                                                                                                                                                                  
	MINSAMECITYTIMESPAN            NUMBER(10,0),                                                                                                                                                                                                                  
	FIRSTCOMETIMESPAN              NUMBER(10,0),                                                                                                                                                                                                                  
	SAMEPROVINCETIMESPAN           NUMBER(10,0),                                                                                                                                                                                                                  
	UPDATEIP                       NUMBER(1,0),                                                                                                                                                                                                                   
	SAVEHISTORYFLAG                NUMBER(10,0)                                                                                                                                                                                                                   
) TABLESPACE SYSTEM;                                                                                                                                                                                                                                           

DROP TABLE COUNTRY;                                                                                                                                                                                                                                           
-- 表名：COUNTRY                                                                                                                                                                                                                                               
-- 备注：                                                                                                                                                                                                                                                      
CREATE TABLE COUNTRY(                                                                                                                                                                                                                                          
	ID                             NUMBER(3,0),                                                                                                                                                                                                                   
	CODE                           NUMBER(4,0),                                                                                                                                                                                                                   
	LANGUAGE                       NUMBER(2,0),                                                                                                                                                                                                                   
	NAME                           VARCHAR2(20),                                                                                                                                                                                                                  
	TS                             NUMBER(6,0),                                                                                                                                                                                                                   
	HANDLE                         NUMBER(1,0)                                                                                                                                                                                                                    
) TABLESPACE SYSTEM;                                                                                                                                                                                                                                           

DROP TABLE CURSTATUS;                                                                                                                                                                                                                                         
-- 表名：CURSTATUS                                                                                                                                                                                                                                             
-- 备注：                                                                                                                                                                                                                                                      
CREATE TABLE CURSTATUS(                                                                                                                                                                                                                                        
	STIME                          DATE,                                                                                                                                                                                                                          
	TOTALTIME                      NUMBER(10,0),                                                                                                                                                                                                                  
	BUFMSGCOUNT                    NUMBER(10,0),                                                                                                                                                                                                                  
	FAIL                           NUMBER(10,0),                                                                                                                                                                                                                  
	TOTAL                          NUMBER(10,0),                                                                                                                                                                                                                  
	LOST                           NUMBER(10,0),                                                                                                                                                                                                                  
	EMPTY                          NUMBER(10,0),                                                                                                                                                                                                                  
	SENDED                         NUMBER(10,0),                                                                                                                                                                                                                  
	SAVEDB                         NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE0                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE1                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE2                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE3                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE4                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE5                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE6                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE7                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE8                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE9                          NUMBER(10,0),                                                                                                                                                                                                                  
	SAVE10                         NUMBER(10,0)                                                                                                                                                                                                                   
) TABLESPACE SYSTEM;