首页 / 更多教程 / 数据库clob类型sql导入
数据库clob类型sql导入
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了数据库clob类型sql导入,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2683字,纯文字阅读大概需要4分钟。
内容图文
oracle 数据库clob sql
1.声明变量法,这种方法用DbVisualizer 9.5导入会报错,用Navicat for Oracle和plsql developer导入没问题。
DECLARE
a CLOB :='jjjjjjj';
b CLOB := 'kkkkkk';
begin
INSERT INTO "TBL_RE_aaaa_DEF" (aaa, aaa, aaa, aaaa, aaa, aaa, aaa) VALUES ('dd5f0cf4113441e68065c8ace8b08258', '1', '1', '2', a,'admin','admin');
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES ('2d5890bbcdc14048a62b6b2c862f6484', '1', '1', '1', b, 'admin','admin');
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES ('483b6fc1f46741e78aaf7fe1751addb6', '1', '0', '0', 'aaaa','admin', 'admin');
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES ('c22e7ebd16574d39b70d2001a3dbba3c', '1', '1', '3', 'aaaa','admin','admin');
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES ('45707bab7a174bcd85e55d8b177faa70', '1', '1', '4', 'aaaaa','admin','admin');
commit;
end;
2.1.字符串拼接法,这种方法用DbVisualizer 9.5、Navicat for Oracle和plsql developer导入没问题。
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES (sys_guid(), '1', '1', '4', 'aaaa','admin','admin');
update usertable set name='abcdefg' where userId = 'aaa';
update usertable set name = name||'hijklmn' where userId = 'aaa';
if exists (select 1 from "TBL_RE_aaaa_DEF" where aaaa = 'dd5f0cf4113441e68065c8ace8b08258')
begin
update "TBL_RE_aaaa_DEF"
set aaaa = 'aaa,'
where aaaa = 'dd5f0cf4113441e68065c8ace8b08258';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa,';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa,'
where aaaa = 'dd5f0cf4113441e68065c8ace8b08258';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa,'
where aaaa = 'dd5f0cf4113441e68065c8ace8b08258';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa'
where aaaa = 'dd5f0cf4113441e68065c8ace8b08258';
end
else
begin
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES ('dd5f0cf4113441e68065c8ace8b08258', '1', '1', '2', 'a','admin','admin');
end
INSERT INTO "TBL_RE_aaaa_DEF" (aaaa, aaaa, aaaa, aaaa, aaaa, aaaa, aaaa) VALUES ('dd5f0cf4113441e68065c8ace8b08258', '1', '1', '2', 'a','admin','admin');
update "TBL_RE_aaaa_DEF"
set aaaa = 'aaaaa,'
where aaaa = 'dd5f0cf4113441e68065c8ace8b08258';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa,';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa,'
where aaaa = 'dd5f0cf4113441e68065c8ace8b08258';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa,';
update "TBL_RE_aaaa_DEF"
set aaaa = aaaa||'aaaa';
内容总结
以上是互联网集市为您收集整理的数据库clob类型sql导入全部内容,希望文章能够帮你解决数据库clob类型sql导入所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。