Oracle数据导出为Insert

最新推荐文章于 2024-03-25 13:32:52 发布
最新推荐文章于 2024-03-25 13:32:52 发布
阅读量9k 收藏 5
点赞数 1
CC 4.0 BY-SA版权
文章标签： oracle insert 数据库 sql server 2010 sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/striveman/article/details/1854327
       当我们对数据库操作时，有时，需要将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')
striveman
关注
oracle导出表insert语句形式,使用程序导出建表语句，及以insert语句形式导出数据_数据库技巧...
weixin_39584405的博客
04-03 1612
前一段时间在弄数据库设计，有时要把一些数据(数据类不大)导到其它类型的数据库里，发现无论是Sql Server、Oracle、MySql，在从库中导出标准的建表和插入数据(即Insert语句)语句时，多少有些不如人意，于是结合自己的要求，自己动手写一个导出的程序。程序在ListBox(lboxAll)中列出指定的数据库中所有的用户表名，选中要导出的表名将会被添加到另一ListBox(lboxSel...
oracle中将查出来的数据转化为insert into语句
韬晦潜胖蛇的专栏
08-17 5446
前言： 最近造数据，迁移至不同测试环境。由于没有建立dblink的权限，所以想将查询出的语句直接转化成insert into语句。 步骤一： 将查询语句输出形式经行修改： 例如： SELECT 'Insert into emp1 (DEPTNO,COMM,SAL,HIREDATE,MGR,JOB,ENAME,EMPNO) ' ||        'Values(' || '''' ||
Oracle导出INSERT语句
06-08
一个用来把Oracle数据库中的数据转换成INSERT语句的小工具。
Oracle使用PL/SQL导出表，结果显示insert语句
weixin_42064877的博客
07-14 3407
Oracle使用PL/SQL导出表，结果显示insert语句
Oracle 使用PLSQL 导出 一个表的insert 语句
最新发布
Saberman
03-25 1394
Oracle 使用PLSQL 导出 一个表的insert 语句
Oracle导出INSERT语句V1.1
06-10
一个用来把Oracle数据库中的数据转换成INSERT语句的小工具。
导出Oracle数据库中表的数据（insert into 形式）
天行健,君子以自强不息！~
06-18 1519
<br />SQL>   select   *   From   aa; <br /><br />ID <br />-------------------- <br />10 <br />20 <br />q <br />10 <br /><br />SQL>   select   'insert   into   aa   values( ' ' '||id|| ' ' '); '   from   aa; <br /><br />'INSERTINTOAAVALUES( ' ' '||ID|| ' '
sqluldr2 4.0.1版本 oracle数据导出工具
03-03
`sqluldr2`是Oracle数据库系统中一个用于快速数据导入和导出的实用程序，它是`SQL*Loader`的一部分，常被用来批量加载大量数据到Oracle表中，或者将数据从Oracle表中导出。在`4.0.1`这个版本中，可能包含了性能优化...
Oracle数据导出工具：生成INSERT语句
Oracle导出INSERT语句V1.1是一款专门用来将Oracle数据库中的数据转换成SQL INSERT语句的工具，这样可以方便用户将数据导入到其他Oracle数据库或者兼容SQL的数据库中。 ### 知识点详解 #### Oracle数据库基础 在...
Oracle导入导出数据的几种方式
09-09
Oracle数据库是目前市场上广泛使用的数据库管理系统之一，它的数据导入导出功能对于数据库的管理和维护至关重要。文章《Oracle导入导出数据的几种方式》介绍了在Oracle数据库中进行数据导入导出的几种常用方式，包括...
Oracle导出INSERT语句V1.1.1
06-10
一个用来把Oracle数据库中的数据转换成INSERT语句的小工具。
windows和unix下通过spool导出oracle数据(导成insert语句)
11-24
windows和unix下通过spool导出oracle的数据,可以精确到表,也可以精确到表的具体数据,导成insert语句或者数据文本都可以
从Oracle数据库中读取数据自动生成INSERT语句的方法
01-21
Oracle INSERT 语句 方法1 我估计有点 SQL 基础的人都会写 INSERT 语句。下面是 SQL 标准写法。 INSERT INTO employees (employee_id, name) VALUES (1, 'Zhangsan'); INSERT INTO employees VALUES (1, 'Shangbo'); 方法2 其实， Oracle 还支持下面的写法，作用和上面的语句完全相同。 INSERT INTO (SELECT employee_id, name FROM employees) VALUES (2, 'Lisi'); 方法3 此外，同其他数据
oracle insert导出,将Oracle表里的数据导出生成insert into 脚本
weixin_36026454的博客
04-03 1214
createorreplaceprocedureprint_insert(v_tnamevarchar2,v_cbatchnumberdefault0)/*v_tname要输出sql的表名作者zh2000@hotmail.comv_cbatch输出commit间隔博客:http://blog.itpub.net/xzh2000*/as/*声明动态游标变量*/typecur_all...
【原创】Oracle使用PL/SQL导出查询结果数据的insert语句
Z_Y_P的博客
09-17 8745
方法一： （此方法为导出某张表中所有数据的insert语句） 步骤： 1.工具 -> 导出表… 2.选择需要导出的表 -> （在SQL插入界面）填写输出文件的路径 -> 点击导出 3.即可在输出文件路径下查看到导出的insert语句。 方法二： （此方法为导出某张表中特定数据的insert语句） 步骤： 1.输入SQL语句，查询指定结果： 2.挑选自己所需要的数据（可按住Ctrl再选中自己需要的某些数据） 3.右键 -> 导出结果 -> SQL文件 4.选择路径 -&
以insert语句方式导出oracle数据库指定表名的数据
icemankimi2的博客
12-02 5806
set serveroutput on DECLARE    /*用于以insert语句方式从oracle数据库导出指定表格的数据*/    lv_tabname  VARCHAR2(2000) := 'TABLENAME';/*目标表格*/    condition VARCHAR2(2000) := ' 1=1 and rownum    lv_sql VARCHAR2(20
ORACLE--数据导入导出
c727657851的博客
07-10 1103
文章目录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插入大量数据的个人经验总结在很多时候，我们会需要对一个表
oracle导出表insert语句存储过程
iteye_14356的博客
05-01 253
Sql代码 createorreplaceprocedureprint_insert(v_tnamevarchar2, v_cbatchnumberdefault0) /* v_tname要输出sql的表名 v_cbatch输出commit间隔 */ as /*声明动态游标变量*/ typecur_alldataisrefcur...
Oracle数据导入/导出命令
Camio007---（Not Null，Unique）
04-20 4904
1、单独备份一个或多个用户：D:>exp scott/tiger file=导出文件D:>exp system/manager owner=(用户1,用户2,…,用户n) file=导出文件2、单独备份一个或多个表：D:>exp 用户/密码 tables=表D:>exp 用户/密码 tables=(表1,…,表2)D:>exp system/manager tables=(用户.表)D:>exp
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值