create table T_SCETRANSFERTAB
(
ID VARCHAR2(20) not null,
SUPERID VARCHAR2(20) not null,
TYPEID VARCHAR2(4),
SERVICENAME VARCHAR2(100),
ACCESSCODE VARCHAR2(10) not null,
CITYCODE VARCHAR2(5) default '0' not null,
USERCLASS VARCHAR2(3) default '0' not null,
DIGITCODE VARCHAR2(20) not null,
USERTYPE NUMBER(4) default 0 not null,
RESULT NUMBER(4) default 0 not null,
TRANSFERCODE VARCHAR2(20) not null,
SERVICEDSN VARCHAR2(20) not null,
LOGDSN VARCHAR2(20) not null,
OPRDBPLYMUSICFLG NUMBER(4) default 0 not null,
FEEFLAG NUMBER(4) default 0 not null,
GETNUMBERFLG NUMBER(4) default 0 not null,
CHECKPASSWORDFLG NUMBER(4) default 0 not null,
CHECKDEBTFEEFLAG NUMBER(4) default 0 not null,
NOTE1 NUMBER(13),
NOTE2 NUMBER(13),
NOTE3 NUMBER(13),
STRING1 VARCHAR2(100),
STRING2 VARCHAR2(100),
STRING3 VARCHAR2(100),
STRING4 VARCHAR2(100),
ISHIDDEN NUMBER(2),
FULLNAME VARCHAR2(600),
VISIBLE NUMBER(1) default 1,
BEGINDATE VARCHAR2(20) default to_char(sysdate,'yyyy-mm-dd'),
ENDDATE VARCHAR2(20) default '3000-01-01',
VPNOTE VARCHAR2(2000),
MESSEGECONTENT VARCHAR2(1400)
)
create table T_CHF_SCEHANDLE
(
ID VARCHAR2(20) not null,
SUPERID VARCHAR2(20) not null,
TYPEID VARCHAR2(4) not null,
SERVICENAME VARCHAR2(60),
ACCESSCODE VARCHAR2(15) not null,
CITYCODE VARCHAR2(60) default '0' not null,
USERCLASS VARCHAR2(20) not null,
DIGITCODE VARCHAR2(20) not null,
USERTYPE NUMBER(4) default 0 not null,
RESULT NUMBER(4) default 0 not null,
TRANSFERCODE VARCHAR2(20) not null,
SERVICEDSN VARCHAR2(20) not null,
LOGDSN VARCHAR2(20) not null,
FEEFLAG NUMBER(4) default 0 not null,
GETNUMBERFLG NUMBER(4) default 0 not null,
CHECKPASSWORDFLG NUMBER(4) default 0 not null,
CHECKDEBTFEEFLAG NUMBER(4) default 0 not null,
OPRDBPLYMUSICFLG NUMBER(4) default 0 not null,
NOTE1 NUMBER(13),
NOTE2 NUMBER(13),
NOTE3 NUMBER(13),
ISHIDDEN NUMBER(2),
FULLNAME VARCHAR2(600),
VISIBLE NUMBER(1) default 1,
BEGINDATE VARCHAR2(20) default '2007-01-01',
ENDDATE VARCHAR2(20) default '3000-01-01',
VPNOTE VARCHAR2(2000),
MESSAGECONTENT VARCHAR2(1400),
SRTYPEID VARCHAR2(60)
);T_SCETRANSFERTAB
表变动T_CHF_SCEHANDLE就别动触发器怎么写
(
ID VARCHAR2(20) not null,
SUPERID VARCHAR2(20) not null,
TYPEID VARCHAR2(4),
SERVICENAME VARCHAR2(100),
ACCESSCODE VARCHAR2(10) not null,
CITYCODE VARCHAR2(5) default '0' not null,
USERCLASS VARCHAR2(3) default '0' not null,
DIGITCODE VARCHAR2(20) not null,
USERTYPE NUMBER(4) default 0 not null,
RESULT NUMBER(4) default 0 not null,
TRANSFERCODE VARCHAR2(20) not null,
SERVICEDSN VARCHAR2(20) not null,
LOGDSN VARCHAR2(20) not null,
OPRDBPLYMUSICFLG NUMBER(4) default 0 not null,
FEEFLAG NUMBER(4) default 0 not null,
GETNUMBERFLG NUMBER(4) default 0 not null,
CHECKPASSWORDFLG NUMBER(4) default 0 not null,
CHECKDEBTFEEFLAG NUMBER(4) default 0 not null,
NOTE1 NUMBER(13),
NOTE2 NUMBER(13),
NOTE3 NUMBER(13),
STRING1 VARCHAR2(100),
STRING2 VARCHAR2(100),
STRING3 VARCHAR2(100),
STRING4 VARCHAR2(100),
ISHIDDEN NUMBER(2),
FULLNAME VARCHAR2(600),
VISIBLE NUMBER(1) default 1,
BEGINDATE VARCHAR2(20) default to_char(sysdate,'yyyy-mm-dd'),
ENDDATE VARCHAR2(20) default '3000-01-01',
VPNOTE VARCHAR2(2000),
MESSEGECONTENT VARCHAR2(1400)
)
create table T_CHF_SCEHANDLE
(
ID VARCHAR2(20) not null,
SUPERID VARCHAR2(20) not null,
TYPEID VARCHAR2(4) not null,
SERVICENAME VARCHAR2(60),
ACCESSCODE VARCHAR2(15) not null,
CITYCODE VARCHAR2(60) default '0' not null,
USERCLASS VARCHAR2(20) not null,
DIGITCODE VARCHAR2(20) not null,
USERTYPE NUMBER(4) default 0 not null,
RESULT NUMBER(4) default 0 not null,
TRANSFERCODE VARCHAR2(20) not null,
SERVICEDSN VARCHAR2(20) not null,
LOGDSN VARCHAR2(20) not null,
FEEFLAG NUMBER(4) default 0 not null,
GETNUMBERFLG NUMBER(4) default 0 not null,
CHECKPASSWORDFLG NUMBER(4) default 0 not null,
CHECKDEBTFEEFLAG NUMBER(4) default 0 not null,
OPRDBPLYMUSICFLG NUMBER(4) default 0 not null,
NOTE1 NUMBER(13),
NOTE2 NUMBER(13),
NOTE3 NUMBER(13),
ISHIDDEN NUMBER(2),
FULLNAME VARCHAR2(600),
VISIBLE NUMBER(1) default 1,
BEGINDATE VARCHAR2(20) default '2007-01-01',
ENDDATE VARCHAR2(20) default '3000-01-01',
VPNOTE VARCHAR2(2000),
MESSAGECONTENT VARCHAR2(1400),
SRTYPEID VARCHAR2(60)
);T_SCETRANSFERTAB
表变动T_CHF_SCEHANDLE就别动触发器怎么写
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货