⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 base_ora.sql

📁 很好用的数据库连接组件
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
 	cbsy INTEGER NULL,
	overflow INTEGER NULL,
	allbusy INTEGER NULL,
	allbusytime INTEGER NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA01 primary key (time,offinum,tkgp,item_no)
	)
/

create table ta02(
 	offinum CHAR(8) NOT NULL,
 	tkgp CHAR(16) NOT NULL,
 	ncit INTEGER NULL,
 	ncct INTEGER NULL,
 	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	termcall INTEGER NULL,
	termansw INTEGER NULL,
	transcall INTEGER NULL,
	transansw INTEGER NULL,
	vacant INTEGER null,
	cnpi INTEGER null,
 	serl FLOAT NULL,
 	rerl FLOAT NULL,
 	cbsy INTEGER NULL,
	locerr INTEGER NULL,
	nores INTEGER NULL,
	sysfault INTEGER NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA02 primary key (time,offinum,tkgp,item_no)
	)
/

create table ta03(
	offinum CHAR(8) NOT NULL,
        cpu_name CHAR(9) NOT NULL,
        cpu_load FLOAT   NULL,
        bhca     INTEGER     NULL,
        time     DATE NOT NULL,
        period   NUMBER(2)  NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA03 primary key (time,offinum,cpu_name,item_no)
	)
/

create table ta04( 	  
	offinum CHAR(8) NOT NULL,
        dest CHAR(16) NOT NULL,
 	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	locbusy INTEGER NULL,
	tolbusy INTEGER NULL,
	cidl INTEGER NULL,
	keycong INTEGER null,
	congest INTEGER NULL,
	vacant INTEGER NULL,
	nonohang INTEGER null,
	nodail INTEGER NULL,
	p_clf INTEGER NULL,
	n_clf INTEGER null,
	btot INTEGER null,
	noansw INTEGER NULL,
	tbusy INTEGER NULL,
	outlimit INTEGER null,
	inlimit INTEGER null,
	noa1 INTEGER NULL,
	noa3 INTEGER NULL,
	nokb INTEGER NULL,
	nokd INTEGER NULL,
 	serl FLOAT NULL,
 	rerl FLOAT NULL,       
 	fail INTEGER NULL,
	reselect INTEGER NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA04 primary key (time,offinum,dest,item_no)
	)
/

create table ta05(
 	offinum CHAR(8) NOT NULL,
	module CHAR(8) NOT NULL,
        ltype CHAR(2) NOT NULL,
 	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	ndal INTEGER NULL,
       	p_clf INTEGER NULL,
        n_clf INTEGER NULL,
        noas INTEGER NULL,
        tbsy INTEGER NULL,
        serl  FLOAT NULL,
        rerl  FLOAT NULL,
        cbsy INTEGER NULL,
        other INTEGER NULL,
  	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA05 primary key (time,offinum,ltype,module,item_no)
	)     
/

create table ta06(
 	offinum CHAR(8) NOT NULL,
	module CHAR(8) NOT NULL,
        ltype CHAR(2) NOT NULL,
        serl  FLOAT NULL,
        rerl  FLOAT NULL,
        berl  FLOAT NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA06 primary key (time,offinum,ltype,module,item_no)
	)
/

create table ta07(   	
	offinum CHAR(8) NOT NULL,
        module CHAR(8) not NULL,
        tdev INTEGER NULL,
        rdev INTEGER NULL,
        seiz INTEGER NULL,
        wtoz INTEGER NULL,
        avdu INTEGER NULL,
        serl FLOAT NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA07 primary key (time,offinum,module,item_no)
	)
/

create table ta08(
 	offinum CHAR(8) NOT NULL,
        module CHAR(8) not NULL,
        tdev INTEGER NULL,
        rdev INTEGER NULL,
        seiz INTEGER NULL,
        wtoz INTEGER NULL,
        avdu INTEGER NULL,
        serl FLOAT NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA08 primary key (time,offinum,module,item_no)
	)
/

create table ta09(
 	offinum CHAR(8) NOT NULL,
        dest CHAR(16) NOT NULL,
        pegs INTEGER NULL,
        cidl INTEGER NULL,
        answ INTEGER NULL,
        clcb INTEGER NULL,
        ctsb INTEGER NULL,
        pcgt INTEGER NULL,
        cull INTEGER NULL,
        nflt INTEGER NULL,
        btot INTEGER NULL,
        nofa1 INTEGER NULL,
        nofa2 INTEGER NULL,
        nofkb INTEGER NULL,  
        nofdk INTEGER NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA09 primary key (time,offinum,dest,item_no)
	)
/

create table ta10(
 	offinum CHAR(8) NOT NULL,
	tkgp CHAR(16) NOT NULL,
	dest CHAR(16) NOT NULL,
	ncct FLOAT NULL,
        pegs INTEGER   NULL,
	seiz INTEGER NULL,
	succ INTEGER NULL,
	answ INTEGER NULL,
	serl FLOAT NULL,
        rerl FLOAT NULL,
	time DATE NOT NULL,
	period NUMBER(2) NOT NULL,
	termcall INTEGER NULL,
	termansw INTEGER NULL,
	transcall INTEGER NULL,
	transansw INTEGER NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA10 primary key (time,offinum,tkgp,dest,item_no)
	)
/

create table ta20(
 	offinum CHAR(8) NOT NULL,
	tkgp CHAR(16) NOT NULL,
	dest CHAR(16) NOT NULL,
	ncct FLOAT NULL,
        pegs INTEGER   NULL,
	seiz INTEGER NULL,
	succ INTEGER NULL,
	answ INTEGER NULL,
	serl FLOAT NULL,
        rerl FLOAT NULL,
	time DATE NOT NULL,
	period NUMBER(2) NOT NULL,
	termcall INTEGER NULL,
	termansw INTEGER NULL,
	transcall INTEGER NULL,
	transansw INTEGER NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA20 primary key (time,offinum,tkgp,dest,item_no)
	)
/

create table ta11(
 	offinum CHAR(8) NOT NULL,
	mnode CHAR(8) not NULL,
	iuser INTEGER NULL,
        callin  INTEGER NULL,
        callout INTEGER NULL,
        answin  INTEGER NULL,
        answout INTEGER NULL,
        inserl  FLOAT NULL,
        inrerl  FLOAT NULL,
        outserl  FLOAT NULL,
        outrerl  FLOAT NULL,
        intcall INTEGER NULL,
        intersel FLOAT NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
        item_no SMALLINT NOT NULL,
	constraint PK_TA11 primary key (time,offinum,mnode,item_no)
	)
/

create table ta12(
 	offinum CHAR(8) NOT NULL,
 	centrexid INTEGER NOT NULL,
 	callout INTEGER NULL,
 	callin INTEGER  NULL,
 	internal INTEGER NULL,
 	outserl FLOAT NULL,
 	inserl  FLOAT NULL,
 	interserl FLOAT NULL,
 	dex CHAR(14) NULL,
 	iuser INTEGER NULL, 
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
 	item_no SMALLINT NOT NULL,
	constraint PK_TA12 primary key (time,offinum,centrexid,item_no)
	)
/

create table ta13(        
	offinum CHAR(8) NOT NULL,
        pbxid INTEGER NOT NULL,
        pegs  INTEGER NULL,
        seiz  INTEGER NULL,
        succ  INTEGER NULL,
        answ  INTEGER NULL,
        ncit  INTEGER NULL,
        ncct  INTEGER NULL,
        serl  FLOAT NULL,
        aerl  FLOAT NULL,
        rerl  FLOAT NULL,
        dex CHAR(14) NULL,
        time DATE NOT NULL,
        period NUMBER(2) NOT NULL,
        item_no SMALLINT NOT NULL,
	constraint PK_TA13 primary key (time,offinum,pbxid,item_no)
	)
/


create table ta14(        
	offinum CHAR(8) NOT NULL,
        linkid  INTEGER NOT NULL,
        unitnum INTEGER NULL,
        occupyper INTEGER NULL,
        switch   INTEGER NULL,
	overflow INTEGER NULL,
	oucongest  INTEGER NULL,
	incongest INTEGER NULL,
	congest	int NULL,
        forbid   INTEGER NULL,
	navailtime INTEGER NULL,
	availlink INTEGER NULL,
	unavaillink INTEGER NULL,
	congestlink INTEGER NULL,
	smsunum	int NULL,
	rmsunum	int NULL,
	ssif	int NULL,
	rsif	int NULL,
	retransoctet	int NULL,
	msudiscard	int NULL,
	outmess INTEGER NULL,
	inmess INTEGER NULL,
	time DATE NOT NULL,
	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA14 primary key (time,offinum,linkid,item_no)
	)
/

create table ta15(
	offinum CHAR(8) NOT NULL,
        no7id INTEGER NOT NULL,
        outmess  INTEGER NULL,
        inmess  INTEGER NULL,
        inack   INTEGER NULL,
        outack  INTEGER NULL,
        trkerr  INTEGER NULL,
        locerr  INTEGER NULL,
        swerr   INTEGER NULL,
	time DATE NOT NULL,
	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA15 primary key (time,offinum,no7id,item_no)
	)
/

create table ta16(
	offinum CHAR(8) NOT NULL,
        tkgp  CHAR(16) NOT NULL,
        sec   INTEGER NULL,
        cgc   INTEGER NULL,
        cfl   INTEGER NULL,
        adi   INTEGER NULL,
        los   INTEGER NULL,
        sst   INTEGER NULL,
        unn   INTEGER NULL,
        ann   INTEGER NULL,
	time DATE NOT NULL,
	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA16 primary key (time,offinum,tkgp,item_no)
	)
/

create table ta17(
	offinum CHAR(8) NOT NULL,
	subunit CHAR(16) not NULL,
        callin   INTEGER NULL,
        callout   INTEGER NULL,
        answin   INTEGER NULL,
        answout   INTEGER NULL,
        insel   FLOAT NULL,
        outsel   FLOAT NULL,
        iuser   INTEGER NULL,
        time DATE NOT NULL,
	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TA17 primary key (time,offinum,subunit,item_no)
	)
/

create table Orog(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	vacant INTEGER NULL,
	opblock INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	p_clf INTEGER NULL,
	n_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	nores INTEGER NULL,
	sysfault INTEGER NULL,
	oroute INTEGER NULL,
 	serl FLOAT NULL,
	locerr INTEGER NULL,
 	rerl FLOAT NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
 	calfault INTEGER NULL,
	ansfault INTEGER NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_OROG primary key (time,offinum,item_no)
      )
/

 create table Og(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	vacant INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	p_clf INTEGER NULL,
	n_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	allbusy INTEGER NULL,
	oroute INTEGER NULL,
 	serl FLOAT NULL,
	rerl FLOAT NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	opblock INTEGER NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_OG primary key (time,offinum,item_no)
	)

/

create table Int(
        offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	vacant INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	p_clf INTEGER NULL,
	n_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	orline INTEGER NULL,
	ecountry INTEGER NULL,
	serl FLOAT NULL,
	rerl FLOAT NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	congest INTEGER NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_INT primary key (time,offinum,item_no)
       )
/

create table Inc(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	p_clf INTEGER NULL,
	n_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	congest INTEGER NULL,
	serl FLOAT NULL,
	rerl FLOAT NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_INC primary key (time,offinum,item_no)
	)
/

create table Trns(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	n_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	congest INTEGER NULL,
	oroute INTEGER NULL,
 	serl FLOAT NULL,
	rerl FLOAT NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	opblock INTEGER NULL,
	allbusy INTEGER NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TRNS primary key (time,offinum,item_no)
	)
/

create table Term(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	n_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	serl FLOAT NULL,
	rerl FLOAT NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_TERM primary key (time,offinum,item_no)
	)
/
create table Inct(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	n_clf INTEGER NULL,
	p_clf INTEGER NULL,
	bittimeout INTEGER NULL,
	serl FLOAT NULL,
	rerl FLOAT NULL,
	locerr INTEGER NULL,
	congest INTEGER NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_INCT primary key (time,offinum,item_no)
	)
/

create table Oric(
 	offinum CHAR(8) NOT NULL,
  	pegs INTEGER NULL,
 	seiz INTEGER NULL,
 	succ INTEGER NULL,
 	answ INTEGER NULL,
	vacant INTEGER NULL,
	noansw INTEGER NULL,
	cbsy INTEGER NULL,
	tbsy INTEGER NULL,
	p_clf INTEGER NULL,
	n_clf INTEGER NULL,
	ndal INTEGER NULL,
	bittimeout INTEGER NULL,
	nonohang INTEGER NULL,
	tollpegs INTEGER NULL,
	tollansw INTEGER NULL,
	spepegs INTEGER NULL,
	speansw INTEGER NULL,
	nores INTEGER NULL,
	sysfault INTEGER NULL,
	serl FLOAT NULL,
	rerl FLOAT NULL,
	locerr INTEGER NULL,
	congest INTEGER NULL,
	calfault INTEGER NULL,
	ansfault INTEGER NULL,
 	time DATE NOT NULL,
 	period NUMBER(2) NOT NULL,
	item_no SMALLINT NOT NULL,
	constraint PK_ORIC primary key (time,offinum,item_no)
	)
/

create table connect_type(
	ltype CHAR(2) not null,
	cname CHAR(60) not null,
	constraint PK_CONNECT_TYPE primary key (ltype)
	)
/

BEGIN
DBMS_OUTPUT.PUT_LINE('-------');
DBMS_OUTPUT.PUT_LINE('END-ORA');
DBMS_OUTPUT.PUT_LINE('-------');
END;
/

REM SPOOL OFF
REM /

QUIT
/
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -