`
Forestsai
  • 浏览: 20226 次
  • 性别: Icon_minigender_1
  • 来自: 南京
社区版块
存档分类
最新评论

BASETAB_810

SQL 
阅读更多

prompt PL/SQL Developer import file
prompt Created on 2011年3月29日 by dxchenc
set feedback off
set define off
prompt Disabling triggers for BASETAB_810...
alter table BASETAB_810 disable all triggers;
prompt Deleting BASETAB_810...
delete from BASETAB_810;
commit;
prompt Loading BASETAB_810...
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '20110326', '20110326', '95504                           ', null, null, null, null, null, null, null, '20110308', '20110308', '29990101', '99991231', '1', null, null, null, null, null, null, '95504                       ', null, 95504, null, null, null, null, '0', null, '0       ', '00000000', '0         ', '0         ', '0             ', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '20110326', '20110326', '95505                           ', null, null, null, null, null, null, null, '20110308', '20110308', '29990101', '99991231', '1', null, null, null, null, null, null, '95505                       ', null, 95505, null, null, null, null, '0', null, '0       ', '00000000', '0         ', '0         ', '0             ', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '20110326', '20110326', '95503                           ', null, null, null, null, null, null, null, '20110308', '20110308', '29990101', '99991231', '1', null, null, null, null, null, null, '95503                       ', null, 95503, null, null, null, null, '1', null, '0       ', '00000000', '0         ', '0         ', '0             ', '1', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 1, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000001                      ', '1', '0', 1688207366, 0, '0         ', 0, 1, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000001                  ', 0, 4008000001, '1   ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 0, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000002                      ', '1', '0', 0, 0, '0         ', 0, 2, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000002                  ', 0, 4008000002, '2   ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '1', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 0, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000003                      ', '1', '0', 0, 0, '0         ', 0, 3, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000003                  ', 0, 4008000003, '3   ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '1', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 0, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000004                      ', '1', '0', 0, 0, '0         ', 0, 4, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000004                  ', 0, 4008000004, '4   ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '1', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 1, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000005                      ', '1', '0', 1688207366, 0, '0         ', 0, 5, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000005                  ', 0, 4008000005, '12  ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 1, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000006                      ', '1', '0', 1688207366, 0, '0         ', 0, 6, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000006                  ', 0, 4008000006, '13  ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 1, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000007                      ', '1', '0', 1688207366, 0, '0         ', 0, 7, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000007                  ', 0, 4008000007, '14  ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 0, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000008                      ', '1', '0', 0, 0, '0         ', 0, 8, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000008                  ', 0, 4008000008, '23  ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 0, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '4008000009                      ', '1', '0', 0, 0, '0         ', 0, 9, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '4008000009                  ', 0, 4008000009, '24  ', 701, 701, '0', '0', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '0', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 0, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '95501                           ', '1', '0', 0, 0, '0         ', 0, 10, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '95501                       ', 0, 95501, '34  ', 701, 701, '0', '1', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '1', '0', 0, '0', 0, 0, null, null, null, null, null);
insert into BASETAB_810 (ACCOUNTAMOUNT, AREASCRFLAG, CHARGEPULSE, CURRENTAMOUNT, CURRENTCALL, CURRENTDISCINDEX, CURRENTDISCOUNT, CURRENTFEE, DEPARTCOUNT, DISCOUNTRATE1, DISCOUNTRATE2, DISCOUNTRATE3, DISCOUNTRATE4, DISCOUNTRATE5, DISCOUNTTYPE, DISTRIBUTETYPE, ENDMONTH, ENDWEEKDAY, UPNUMBER, LANGUAGETYPE, LIMITFLAG, MAINMSG, MAXCALL, PINNUMBER, REGISTDISCOUNT, ROUTEFLAG, STARTDATE, STATISTICSTART, STATISTICSTOP, STOPDATE, SUBSTATE, TOPFEE1, TOPFEE2, TOPFEE3, TOPFEE4, TOPFEE5, TOTALFEE, USERIDENTIFIER, PUBLICUSERID, USERID, ROUTESEQUENCE, SCP, SDP, DISCOUNTFLAG, GROUPUSERFLAG, REGISTDISCOUNT1, LIMITSTARTDATE, LIMITSTOPDATE, MANAGERPIN, PREPINNUMBER, INURETIME, MOBILEAREAFLAG, WELCOMEMSGFLAG, WELCOMEMSGID, NAVIGATEMENUFLAG, NAVIGATEVOICEID, NAVROUTERNUMBER, IFWRITECALLINFO, IFWRITEVOICEINFO, PLAYDVOICEFLAG, FIXEDAREAFLAG, BAKNUMSTATE)
values (0, '0', 0, 0, 0, 0, 100, 0, 1, 100, 100, 100, 100, 100, '1', '0', '20110326', '20110326', '95502                           ', '1', '0', 1688207366, 0, '0         ', 0, 11, '20110308', '20000101', '29990101', '99991231', '1', 0, 0, 0, 0, 0, 0, '95502                       ', 0, 95502, '123 ', 701, 701, '0', '1', 0, '00000000', '00000000', '0         ', '0         ', '00000000000000', '1', '0', 0, '0', 0, 0, null, null, null, null, null);
commit;
prompt 14 records loaded
prompt Enabling triggers for BASETAB_810...
alter table BASETAB_810 enable all triggers;
set feedback on
set define on
prompt Done.

分享到：
| SUBSCRIBER
评论
发表评论

文章已被作者锁定，不允许评论。

相关推荐

    如何解决informix数据库锁表问题.doc

    输出结果中，我们可以看到被锁的表名为 basetab_mvpn。 五、锁表的释放 锁表的释放可以通过 onstat –u 命令来实现。例如： ``` onstat –u ``` 输出结果中，我们可以看到 owner 为 d656e774 的线程，_address ...

    8-WLAN各类投诉处理方法-v2.pdf

    此外，如果用户状态为“激活”，还需查看RadiusDB中的basetab_0210表，检查stopseason字段，非零值意味着用户被暂停，需要进一步确认并调整。 - 用户登录时出现“1……2……3……4……”的提示，这代表四种常见...

    Oracle数据库的日常使用命令

    - **授予实体权限**：使用`grant select, insert on basetab to imuse01;`命令将表basetab上的SELECT和INSERT权限授予用户imuse01。 - **回收实体权限**：使用`revoke select on basetab from imuse01;`命令从用户...

    数据库设计和开发规范

    例如：`SYS_LOGTAB` 和 `DEV_BASETAB`。建议表名以英文单数形式命名。 #### 五、SQL语句规范 - **大小写规范**：所有SQL关键字、函数等应使用大写，其他部分使用小写。 - **分号终止**：每个SQL语句末尾必须加上...

    react-base-table：react表组件，用于显示具有高性能和灵活性的大型数据集

    React基表 BaseTable是一个React表组件，可显示具有高性能和灵活性的大型数据集 安装 # npm npm install react-base-table --save # yarn yarn add react-base-table 用法 import BaseTable , { Column } ...// BaseTab

Magicbox
Global site tag (gtag.js) - Google Analytics