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

📄 base_ora.sql

📁 很好用的数据库连接组件
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
        BEGIN
            s := 'drop table ta13 cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'TA14');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table ta14 cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'TA15');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table ta15 cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'TA16');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table ta16 cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'TA17');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table ta17 cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'OROG');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Orog cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'OG');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Og cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'INT');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Int cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'INC');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Inc cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'TRNS');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Trns cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'TERM');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Term cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'INCT');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Inct cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'ORIC');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table Oric cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

BEGIN
DECLARE
cnt integer := 0;
BEGIN
    SELECT 1 INTO cnt FROM dual WHERE exists(SELECT * FROM user_tables WHERE table_name = 'CONNECT_TYPE');
    IF cnt!=0 THEN
        DECLARE s  VARCHAR2(500);
        BEGIN
            s := 'drop table connect_type cascade constraints';
            DBMS_OUTPUT.PUT_LINE(s);
            EXECUTE IMMEDIATE  s;                
        END;
    END IF;
exception
    WHEN no_data_found  THEN
        DBMS_OUTPUT.PUT_LINE(cnt);
END;
END;
/

create table almrack(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	circuit         CHAR(10)        null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMRACK primary key (time,offinum,serialno)
	)
/

create table almcs7(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	spcindex        CHAR(7)         null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMCS7 primary key (time,offinum,serialno)
	)
/

create table almn7lk(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	snode           CHAR(7)         null,
	slid            CHAR(7)         null,
	indx            CHAR(7)         null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMN7LK primary key (time,offinum,serialno)
	)
/

create table almcpu(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	value           FLOAT           null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)    null,
	constraint PK_ALMCPU primary key (time,offinum,serialno)
	)
/

create table almpcm(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	snode           CHAR(7)         null,
	circuit         CHAR(10)        null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)	null,
	constraint PK_ALMPCM primary key (time,offinum,serialno)
	)
/

create table almrst(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	dev             CHAR(8)         null,
	dev_no          CHAR(10)        null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMRST primary key (time,offinum,serialno)
	)
/

create table almenv(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	value           FLOAT           null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMENV primary key (time,offinum,serialno)
	)
/

create table almclk(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
        alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMCLK primary key (time,offinum,serialno)
	)
/

create table almcomm(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	s_ipaddr        CHAR(18)        null,
	d_ipaddr        CHAR(18)        null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	constraint PK_ALMCOMM primary key (time,offinum,serialno)
	)
/

create table almspc(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
     	text            VARCHAR2(100)    null,
	constraint PK_ALMSPC primary key (time,offinum,serialno)
        )
/

create table almoep(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
	alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	circuit         CHAR(10)        null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	text            VARCHAR2(120)    null,
	constraint PK_ALMOEP primary key (time,offinum,serialno)
        )
/

create table almpower(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
        alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
	text            VARCHAR2(120)    null,
	constraint PK_ALMPOWER primary key (time,offinum,serialno)
        )
/

create table almv5(
	offinum         CHAR(8)         not null,
	alm_lev         NUMBER(1)         null,
	mnode           NUMBER(3)        null,
	rack            NUMBER(3)        null,
	shelf           NUMBER(3)        null,
	card            NUMBER(3)        null,
        alm_cat         CHAR(28)        null,
	time            DATE        not null,
	ctime           DATE        null,
	code		SMALLINT	null,
	serialno        INTEGER         not null,
	v5id            CHAR(4)         null,
        result          CHAR(6)         null,
	alarmcode       VARCHAR2(255)     null,
      	text            VARCHAR2(120)    null,
	constraint PK_ALMV5 primary key (time,offinum,serialno)
        )
/

create table offirack (
	offinum CHAR(8) not null,
	module  NUMBER(3) not null,
	rack    NUMBER(3) not null,
	shelf   NUMBER(3) not null,
	card    NUMBER(3) not null,
	type    SMALLINT    null,
	state   SMALLINT    null,
	tag CHAR(1) null,
	constraint PK_OFFIRACK primary key ( offinum,module,rack,shelf,card )
	)
/

create table boardtype (
	section NUMBER(3) not null,
	typeid  SMALLINT    not null,
	typename    CHAR(20)    not null,
	width   NUMBER(3) DEFAULT  1  not null,
	tag CHAR(1) null,
	constraint PK_BOARDTYPE primary key ( section,typeid )
)
/

create table boardstate (
	section NUMBER(1) not null,
	stateid SMALLINT    not null,
	statename   CHAR(16)    not null,
	bgdcolor    CHAR(10)    null,
	tag CHAR(1) null,
	constraint PK_BOARDSTATE primary key  ( section,stateid )
)
/

create table ta01(
 	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,
	localbusy INTEGER NULL,
	tollbusy INTEGER NULL,
	cidl INTEGER null,
	keycong INTEGER null,
	opblock INTEGER NULL,
	vacant INTEGER NULL,
	cnpi INTEGER null,
	nonohang INTEGER null,
	nodail INTEGER null,
	p_clf INTEGER null,
	n_clf INTEGER null,
	btot INTEGER null,
	noansw INTEGER NULL,
	tbsy INTEGER null,
	outlimit INTEGER null,
	inlimit INTEGER null,
	reselect INTEGER NULL,
	noa1 INTEGER null,
	noa3 INTEGER null,
	nokb INTEGER null,
	nokd INTEGER null,
	serl FLOAT NULL,
 	rerl FLOAT NULL,
123

⌨️ 快捷键说明

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