Oracle数据导出为Insert

striveman striveman 博客等级 墨衍会员 · AI 创作全网分发 墨衍智能分发 本文由作者通过墨衍一键同步至各平台 1分发平台 9.2k累计阅读 9.3k平均单平台 已同步平台 优快云 微信公众号 微博 知乎 掘金 百家号 博客园 抖音 小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网 我也要 码龄20年
关注
原创 最新推荐文章于 2026-03-14 16:38:51 发布 9.2k 阅读 AI 写同款· GEO 优化 ›
Oracle导出INSERT语句 一个用来把Oracle数据库中的数据转换成INSERT语句的小工具。 立即下载
       当我们对数据库操作时，有时，需要将Oracle数据库表中的数据导出为Insert 语句，这样可以在其它的数据库上执行。 这两天，我将以前用Oracle数据库的开发，用SQL Server 重新写了一遍，为了用Oracle数据库中的数据，参考网上的东东，先将相关的SQL 语句写出，供大家参考使用。
     
Select 'Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) ' 
|| 'Values('||''''|| Idnumber ||''''|| ',''' || Type ||''''|| ','''|| Lessor || ''''||',''' || RoomID ||''''|| ','''
|| to_char(Indate,'yyyy-MM-dd hh24:mi:ss') ||''''||',''' || '2007-10-28' || ''''||')' 
from  floating_population_lease_info

得到的结果如下：

Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011851','1','000027','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011878','1','000028','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011894','1','000029','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011915','1','000030','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011931','1','000031','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011958','1','000032','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012117','1','000040','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012133','1','000041','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301215X','1','000042','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012176','1','000043','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012192','1','000044','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012213','1','000045','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301223X','1','000046','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012256','1','000047','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012272','1','000048','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012299','1','000049','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301231X','1','000050','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012336','1','000001','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012352','1','000002','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012379','1','000003','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012395','1','000004','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012416','1','000005','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012432','1','000006','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012459','1','000007','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012475','1','000008','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012491','1','000009','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012512','1','000010','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012539','1','000011','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012555','1','000012','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012571','1','000013','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012598','1','000014','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012619','1','000015','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012635','1','000016','100','2007-10-10 00:25:05','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012598','1','000027','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012619','1','000028','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012635','1','000029','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012651','1','000030','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012678','1','000031','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012694','1','000032','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012715','1','000033','100','2007-10-10 00:20:35','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011130','1','000034','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011157','1','000035','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011173','1','000036','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301119X','1','000037','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011210','1','000038','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011237','1','000039','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011253','1','000040','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301127X','1','000041','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011296','1','000042','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011317','1','000043','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011333','1','000044','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301135X','1','000045','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011376','1','000046','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011392','1','000047','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011413','1','000048','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301143X','1','000049','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011616','1','000008','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011632','1','000009','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011659','1','000010','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011675','1','000011','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011691','1','000012','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011712','1','000013','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011739','1','000014','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011755','1','000015','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011771','1','000016','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011798','1','000017','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011819','1','000018','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011835','1','000019','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011851','1','000020','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011878','1','000021','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011894','1','000022','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011915','1','000023','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011931','1','000024','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011958','1','000025','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011974','1','000026','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011990','1','000027','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012010','1','000028','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012037','1','000029','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012053','1','000030','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301207X','1','000031','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012096','1','000032','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012117','1','000033','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012133','1','000034','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301215X','1','000035','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012352','1','000045','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012379','1','000046','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012395','1','000047','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012416','1','000048','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012432','1','000049','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012459','1','000050','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012475','1','000001','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012491','1','000002','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012512','1','000003','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012539','1','000004','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012555','1','000005','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012571','1','000006','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012598','1','000007','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012619','1','000008','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012635','1','000009','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012651','1','000010','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012678','1','000011','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012694','1','000012','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012715','1','000013','100','2007-10-10 00:20:43','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011130','1','000014','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011157','1','000015','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011173','1','000016','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301119X','1','000017','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011210','1','000018','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011237','1','000019','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011253','1','000020','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011456','1','000030','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011472','1','000031','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011499','1','000032','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301151X','1','000033','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011536','1','000034','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011552','1','000035','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011579','1','000036','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011595','1','000037','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011616','1','000038','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011632','1','000039','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011659','1','000040','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011675','1','000041','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011691','1','000042','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011712','1','000043','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011739','1','000044','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011755','1','000045','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011771','1','000046','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011931','1','000004','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011958','1','000005','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011974','1','000006','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003011990','1','000007','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012010','1','000008','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012037','1','000009','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012053','1','000010','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301207X','1','000011','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012096','1','000012','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012117','1','000013','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('410101198003012133','1','000014','100','2007-10-10 00:20:51','2007-10-28')
Insert into floating_population_lease_info (Idnumber,Type,Lessor,RoomID,Indate,LeftDate) Values('41010119800301215X','1','000015','100','2007-10-10 00:20:51','2007-10-28')
标签
#oracle #insert #数据库 #sql server #2010
#sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
实战指南：如何用Kamailio+FreeSWITCH搭建高并发企业通信系统（附配置模板） 本文提供了一份实战指南，详细介绍了如何利用Kamailio与FreeSWITCH构建高并发企业通信系统。通过将Kamailio作为高性能SIP信令平面处理路由与负载均衡，FreeSWITCH作为媒体与应用平面负责通话与业务逻辑，实现信令与媒体分离的电信级架构。文章深入解析了架构设计、核心配置、集群部署与性能优化，并附有配置模板，旨在帮助企业构建可水平扩展、高可用的通信解决方案。 阅读详情

相关推荐

USB-C快充协议分析仪：QC/PD双协议识别与功率监测设计

USB-C快充协议是现代移动设备能量传输的核心技术标准，其本质是通过物理层电压特征（如DP/DM组合、CC线BMC编码）实现动态电压协商。理解协议握手原理对充电器研发、兼容性测试及故障诊断至关重要。本方案聚焦受电端（Sink）视角，基于FUSB302B与高阻抗DP/DM采样电路，实现QC2.0/QC3.0/QC4+与PD2.0/PD3.0的实时识别与状态机解析；结合INA219高精度电流检测与μs级同步采样，达成±0.06%功率测量精度。典型应用于快充芯片验证、产线协议一致性测试及第三方评测，为USB供电系

weixin_42153793的博客 245

【原创】Oracle使用PL/SQL导出查询结果数据的insert语句

方法一： （此方法为导出某张表中所有数据的insert语句） 步骤： 1.工具 -> 导出表… 2.选择需要导出的表 -> （在SQL插入界面）填写输出文件的路径 -> 点击导出 3.即可在输出文件路径下查看到导出的insert语句。 方法二： （此方法为导出某张表中特定数据的insert语句） 步骤： 1.输入SQL语句，查询指定结果： 2.挑选自己所需要的数据（可按住Ctrl再选中自己需要的某些数据） 3.右键 -> 导出结果 -> SQL文件 4.选择路径 -&

Z_Y_P的博客 9174

IPD流程中CBB管理的5个致命误区，第3个坑了80%的团队

本文深入剖析了IPD流程中CBB管理的五个致命误区，尤其指出缺乏有效的度量与激励机制是影响80%团队的核心陷阱。文章强调CBB的核心在于前瞻性设计，而非简单归档，并需平衡通用性与产品竞争力，同时建立持续运营机制，确保CBB与市场需求对齐，从而真正实现缩短开发周期、降低成本的目标。

weixin_29234423的博客 569

ORACLE--数据导入导出

文章目录1 导出INSERT语句，通过SQL来导入2 通过PL/SQL Developer工具进行导出导入3 EXP/IMP工具4 EXPDP/IMPDP数据泵(CMD窗口运行)1）路径相关内容2）数据泵导出数据4）数据泵导入数据5 SPOOL/SQLLDR1）数据导出SPOOL (需要在SQLPLUS中运行)2）数据导入SQLLDR (不需要连接数据库用户，需要进入安装数据库的计算机用户) 1 导出INSERT语句，通过SQL来导入 使用insert插入大量数据的个人经验总结在很多时候，我们会需要对一个表

c727657851的博客 1384

手把手教你用Python实现双三次插值（附OpenCV对比测试）

本文深入解析了双三次插值算法的数学原理，并提供了从零开始的Python实现教程。通过与OpenCV官方实现的对比测试，详细评估了不同插值算法（包括最邻近差值、双线性插值）在图像质量与计算性能上的差异，帮助开发者掌握高质量图像缩放的核心技术。

weixin_29310605的博客 296

【局部规划模块轨迹优化算法】Teb_planner规划算法

认知有限，望大家多多包涵，有什么问题也希望能够与大家多交流，共同成长！本文先对****做个简单的介绍，具体内容后续再更，其他模块可以参考去我其他文章提示：以下是本篇文章正文内容由于ROS中的局部路径规划器比较老了，所以我推荐大家使用比较新的局部路径规划器teb_local_planner。teb_local_planner是基于弹性时间带碰撞约束的算法，算法将动态障碍物、运行时效、路径平滑性等约束做综合考虑，在复杂环境下有更优秀的表现。

qq_35635374的博客 951

ORACLE 常用语句 记录

Oracle 数据库导入导出语句

ayt007的博客 786

109. SAP ABAP 应用程序中的锁机制和工作原理介绍

SAP ABAP 系统中的锁概念，是 SAP ABAP 为了保证`数据一致性`而引入的一种保护机制。 像 SAP 这种复杂的企业级应用，系统中同一时间段的同一份数据，可能会有多个 Transaction(终端用户或者 API )同时进行读写操作。为了防止出现数据不一致，SAP ABAP 引入了锁机制。 这种锁机制并非数据库服务器层面的锁，而是在 SAP ABAP 应用服务器层面上工作，加锁和解锁都由专门的 ABAP Function Module 来完成。

2007 年 ~ 2025 年，深耕 SAP 技术 18 年 1468

Oracle 使用PLSQL 导出 一个表的insert 语句

Oracle 使用PLSQL 导出 一个表的insert 语句

Saberman 1640

基于深度学习的灰度图像气泡群识别与优化

灰度图像气泡群深度学习识别优化研究 本研究针对MATLAB实现的深度学习气泡群识别系统在从1445个点到4992个点扩展时出现的精度不稳定问题，提出了一套完整的解决方案。文章首先分析了问题根源，包括数据复杂度增加、类别不平衡、网络容量不足等因素，然后系统性地提出了数据预处理增强、网络架构优化、训练策略调整和后处理算法改进等优化措施。通过改进的U-Net架构、自适应直方图均衡化等技术创新，有效提升了模型在大规模气泡群图像上的识别精度和稳定性，为化工、生物医学等领域的灰度图像分析提供了可靠的技术支持。

max500600的博客 412

【RT-DETR涨点改进】全网独家创新、细节涨点改进篇 | ICML 2024 | RT-DETR引入ICB交互式卷积模块和ASB自适应频谱模块，助力目标检测、异常检测有效涨点、含多种创新改进点

RT-DETR目标检测模型通过引入ICB和ASB模块实现性能提升。ICB模块采用多尺度卷积交互，有效捕获局部和长程依赖特征；ASB模块通过自适应频域滤波优化特征表示，降低噪声干扰。两者结合使模型在复杂场景中表现更优，显著提升检测精度和鲁棒性。文章详细介绍了模块原理、代码实现及配置方法，并提供了8种改进版本的YAML配置文件，适用于不同网络结构。这些创新改进为RT-DETR模型提供了高效涨点方案，特别适合复杂背景和高噪声环境下的目标检测任务。

Ai缝合怪、助力小伙伴高效发论文 213

oracle insert导出,将Oracle表里的数据导出生成insert into 脚本

createorreplaceprocedureprint_insert(v_tnamevarchar2,v_cbatchnumberdefault0)/*v_tname要输出sql的表名作者zh2000@hotmail.comv_cbatch输出commit间隔博客:http://blog.itpub.net/xzh2000*/as/*声明动态游标变量*/typecur_all...

weixin_36026454的博客 1319

【Qt图书管理系统】5.完整版源码及下载地址

Qt图书管理系统完整源码下载。

小鱼酱的博客 7001

以insert语句方式导出oracle数据库指定表名的数据

set serveroutput on DECLARE    /*用于以insert语句方式从oracle数据库导出指定表格的数据*/    lv_tabname  VARCHAR2(2000) := 'TABLENAME';/*目标表格*/    condition VARCHAR2(2000) := ' 1=1 and rownum    lv_sql VARCHAR2(20

icemankimi2的博客 5861

pscad IEEE标准系统搭建说明

pscad IEEE标准系统搭建说明，包含典型的IEEE 9节点、14节点、30节点、39节点和118节点系统。内含标准测试系统的原始数据和潮流结果。

Probability and Statistics - 4th edition

Probability and Statistics - 4th edition

oracle数据库指定表导出,以insert语句方式导出oracle数据库指定表名的数据

SET SERVEROUTPUT ONDECLARE/*用于以INSERT语句方式从ORACLE数据库导出指定表格的数据*/LV_TABNAME VARCHAR2(2000) := 'MY_TAB';/*目标表格*/CONDITION VARCHAR2(2000) := ' 1=1 AND ROWNUM<6 ';/*导出条件*/LV_SQL VARCHAR2(32767) := '';TA...

weixin_34828613的博客 943

假人有限元模型

假人模型，车辆碰撞假人有限元模型，适合做乘员安全的研究者利用

oracle怎么导表数据,如何将Oracle表里的数据导出成insert into脚本?

如何将Oracle表里的数据导出成insert into脚本?转载，请保留原作者的名字。create or replace procedure print_insert(v_tname varchar2,v_cbatch number default 0)/*v_tname 要输出sql的表名 作者zh2000@hotmail.comv_cbatch 输出commit间隔 博客:http://bl...

weixin_34970098的博客 365

IEM模型，地表粗糙度模拟

利用微波反演土壤水分时候，利用IEM模型可以实现对随机地表的模拟

问题解决：dbeaver导出结果集功能-导出insert类型的sql文件，再次手工执行插入oracle数据库报ORA-00933

计划利用工具将oracle数据库表中数据迁移到另一个库中。

qq_37190962的博客 1693

将Oracle表里的数据导出生成insert into 脚本

将Oracle表里的数据导出生成insert into 脚本

5444

怎样将Oracle中的数据导出为insert脚本

pl/sql developer 的tools菜单下有export table,和export object，后者可以导出脚本

iteye_10711的博客 447

Oracle数据库clob字段导出为sql insert插入语句

oracle数据库的clob字段导出为sql insert插入语句可以分三种情况：1，clob没有换行符；2，clob有换行符但不以分号结尾；3，clob有换行符并且以分号结尾。 clob没有换行符使用dbms_lob.substr(clobName) clobName查询并导出即可，导...

chuanleipeng9721的博客 2936

如何将Oracle表里的数据导出生成insert into脚本?

create or replace procedure print_insert(v_tname varchar2,v_cbatch number default 0) /* v_tname 要输出sql的表名 作者zh2000@hotmail.com v_cbatch 输出commit间隔 博客:http://blog.itpub.net/xzh2000 */ as /* 声明动态游...

Java365 750

oracle导出表insert语句形式,使用程序导出建表语句，及以insert语句形式导出数据_数据库技巧...

前一段时间在弄数据库设计，有时要把一些数据(数据类不大)导到其它类型的数据库里，发现无论是Sql Server、Oracle、MySql，在从库中导出标准的建表和插入数据(即Insert语句)语句时，多少有些不如人意，于是结合自己的要求，自己动手写一个导出的程序。程序在ListBox(lboxAll)中列出指定的数据库中所有的用户表名，选中要导出的表名将会被添加到另一ListBox(lboxSel...

weixin_39584405的博客 1685

oracle导出表数据为insert语句

相关网站：http://apps.hi.baidu.com/share/detail/33786367 说明：有截图 很容易明白

赵士杰的博客 1052

oracle 导出/导入数据

1.导出insert sql语句 将oracle表中数据以insert into 语句导出，存储过程实现 创建游标对象 create or replace package test.PK_EXPORT_TABLE is type result is ref cursor;end ; 创建存储过程 CREATE OR REPLACE PROCEDURE P_EXPORT_TABLE...

Ronin_88的博客 994

用PL/SQL把oracle数据库表里的数据导出成insert语句的形式

2019独角兽企业重金招聘Python工程师标准>>> ...

weixin_33768481的博客 1404

怎么导出oracle数据包,Oracle-工具-SPOOL导出数据文件

通过SPOLL将Oracle数据导出为INSERT语句，只要将导出数据格式改为INSERT格式即可。set feedback offset heading offset termout onset verify offset echo offset pagesize 1000set linesize 100define filepath= 'f:\1.log'prompt *** Spooling...

weixin_35995951的博客 507
上一篇： Oracle获取前10条数据
下一篇： LINQ TO SQL项目实战---用户登录篇
点赞 1
评论 0
书签 书签 5
striveman
striveman
博客等级 码龄20年 27粉丝 55原创
+ 关注
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值