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]
Sent: Friday, October 25, 2013 1:39 PM
Subject: [Toad for Oracle - Discussion Forum] Issue with
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 on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
