SUBSCRIBER

prompt PL/SQL Developer import file
prompt Created on 2011年3月29日 by dxchenc
set feedback off
set define off
prompt Disabling triggers for SUBSCRIBER...
alter table SUBSCRIBER disable all triggers;
prompt Deleting SUBSCRIBER...
delete from SUBSCRIBER;
commit;
prompt Loading SUBSCRIBER...
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000001, '上海                                              ', 1, null, null, 0, null, null, null, 1, null, 0, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000002, '江苏                                              ', 1, null, null, 0, null, null, null, 1, null, 4, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000003, '江苏                                              ', 1, null, null, 0, null, null, null, 1, null, 4, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000004, '江苏                                              ', 1, null, null, 0, null, null, null, 1, null, 4, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000005, '新疆                                              ', 1, null, null, 0, null, null, null, 1, null, 17, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000006, '海南                                              ', 1, null, null, 0, null, null, null, 1, null, 16, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000007, '内蒙                                              ', 1, null, null, 0, null, null, null, 1, null, 28, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000008, '山西                                              ', 1, null, null, 0, null, null, null, 1, null, 29, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (4008000009, '黑龙江                                            ', 1, null, null, 0, null, null, null, 1, null, 23, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (95501, '重庆                                              ', 1, null, null, 0, null, null, null, 1, null, 11, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (95502, '江苏                                              ', 1, null, null, 0, null, null, null, 1, null, 4, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (95503, '上海                                              ', 1, null, null, 0, null, null, null, 1, null, 0, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (95504, '北京                                              ', 1, null, null, 0, null, null, null, 1, null, 1, null, null, null, null);
insert into SUBSCRIBER (USERID, USERNAME, USERPROPERITY, POSTADDRESS, ZIPCODE, ACCOUNTTYPE, ACCOUNT, COMMPERSON, TELEPHONE, CERTIFICATETYPE, CERTIFICATE, AREAID, DEALTIME, DEALOPR, DEALSMAP, UNITNAME)
values (95505, '山东                                              ', 1, null, null, 0, null, null, null, 1, null, 30, null, null, null, null);
commit;
prompt 14 records loaded
prompt Enabling triggers for SUBSCRIBER...
alter table SUBSCRIBER enable all triggers;
set feedback on
set define on
prompt Done.