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.
分享到:
相关推荐
VC代码实例:发布者&订阅者(Publisher & Subscriber)之C++完全代码实例。附工程全部源文件,可直接运行。 供初学者参考。
Introduction of publish/subscriber system
PublisherSubscriber(发布订阅者)消息模式开发流程
Laravel开发-subscriber Viviniko用户服务提供商
Introduction to ROS Publisher-Subscriber Nodes是一本关于ROS机器人系统入门的基础书籍
oauth-subscriber, 使用 OAuth 1.0 ( Guzzle 6 ) 标记Guzzle请求 Guzzle OAuth订阅服务器使用 OAuth 1.0标记HTTP请求。 使用使用者密钥。消费者机密。OAuth令牌和OAuth密钥对请求进行签名。这里版本仅适用于 Guzzle ...
NULL 博文链接:https://jasonxiawanjian.iteye.com/blog/1884568
AMSS - Advanced Mobile Subscriber Software 架构说明
pose_subscriber.cpp
Subscriber: administrator Subscription Code: nLR7ZL-655342-54657656405281154 MyEclipse 6.0GA / M1 和 5.5GA 注册码 Subscriber: www.1cn.biz Subscriber Code: jLR8ZC-655355-5450765457039125 或者 ...
Cisco用户边界服务管理器Cisco Subscriber Edge Services Manager (SESM) 是一套基于Windows、UNIX或Linux服务器的软件。
在目标目录中解压target/subscriber-2.0.zip /subscriber-2.0 /angularUI /lib /postman startServer.sh 启动服务器 $ ./startServer.sh <port> with default port=9000] 请求在tmp中持久化 应用程序接口 ...
npm install redux-subscriber --save 用法 store.js import { createStore } from 'redux' ; import initSubscriber from 'redux-subscriber' ; const store = createStore ( ... ) ; // "initSubscriber" ...
将以下内容添加到您的composer.json中: { "require" : { "guzzlehttp/oauth-subscriber" : "^0.5" }}使用订户这是显示如何向Twitter REST API发送经过身份验证的请求的示例: use GuzzleHttp \ Client ;...
您可以通过下载(或克隆)源来安装example-add_subscriber_send_instant 。 在脚本顶部输入您的 ActiveCampaign URL 和 API 密钥。 下面的例子: define("ACTIVECAMPAIGN_URL", ...
subscriber_contract_example: 链上订阅者合约,通过callback绑定、查询和接收来自预言机的响应 布局: SSubscriber.sol :这是您的订阅者合约,它将绑定-查询-接收响应,随时更改名称和结构,这只是一个示例。 ...
rosserial_arduino_multiple_publisher_and_subscriber
ActiveMQ_Topic_Subscriber 这用于消耗的主题
ssl-subscriber-agreement-cn
LICENSEE -> Your subscriber ID LICENSE_KEY -> Subscription code 【Enable Now】 I already have an activation code 【Activate Now】 【Skip Email】 ACTIVATION_KEY -> 【Activate Now】 等待成功