# RE: Issue with

**URL:** <https://forums.toadworld.com/t/re-issue-with/27314>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 25, 2013, 11:45am UTC](https://forums.toadworld.com/t/re-issue-with/27314 "2013-10-25T11:45:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 25, 2013, 11:45am UTC](https://forums.toadworld.com/t/re-issue-with/27314/1 "2013-10-25T11:45:50Z")

</div>

Toad doesn’t have a limit in how many records you can insert.

Your insert statement is wrong. It should be like this:

Insert into ABC (ID) Values (‘A1234’);

Insert into ABC (ID) Values (‘B1231’);

Insert into ABC (ID) Values (‘c213456’);

etc

commit;

If your data is in a text file or excel file, take a look at Toad’s data import wizard. Right-click on the table in the Schema Browser, and choose “Import  
Data”.

It will be much faster than individual insert statements.

**From:** abraham30 [[mailto:bounce-abraham30@toadworld.com](mailto:bounce-abraham30@toadworld.com)]

**Sent:** Friday, October 25, 2013 1:39 PM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** [Toad for Oracle - Discussion Forum] Issue with

**[Issue with](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20607.aspx)**

Thread created by abraham30

Hello Everyone,

I am new to this forum. I have created one temporary table where I want to insert 20000 records. But the problem with Toad is that it does not support more than 700 records. Is there any way  
to solve alternatively.

I have also used import procedure to insert records directly into the table. But for 1500 records, it tooks 1 hour time for insertion.

Can anyone help me simplest procedure .

My table

create table ABC (ID varchar2(10));

Insert into ABC values(‘A1234’, ‘B1231’, ‘c213456’, ‘D1200’,--------------------etc…)

Advance thanks for your help

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20607.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20607.aspx?AbuseContentId=892f6c3e-8118-4d3c-a001-d9575f73912d&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/015c4a75/5miSFi.gif)

---

<div class="post-metadata">

**Author:** ![abraham30](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@abraham30](https://forums.toadworld.com/u/abraham30)\
**Post date:** [October 25, 2013, 12:58pm UTC](https://forums.toadworld.com/t/re-issue-with/27314/2 "2013-10-25T12:58:24Z")

</div>

Thanks John.