<div>
<br />
- connect to database<br />
- File&gt; Open&gt; { browse and select sql file to execute }<br />
- Once loaded, click on Run Script.<br />

</div>



- connect to database
- File> Open> { browse and select sql file to execute }
- Once loaded, click on Run Script.


<div>
does this loadup all records i.e<br />
<br />
i have 100s of records to upload at once?<br />
<br />
have u an example?just wanna make sure i dont overlook anything!<br />
<br />
tia<br />
<br />
r
</div>


does this loadup all records i.e

i have 100s of records to upload at once?

have u an example?just wanna make sure i dont overlook anything!

tia

r

<div>
insert into tablea(fielda)values('1');<wbr /><br />
insert into tablea(fielda)values('2');<wbr /><br />
insert into tablea(fielda)values('3');<wbr /><br />
insert into tablea(fielda)values('4');<wbr /><br />
insert into tablea(fielda)values('5');<wbr /><br />
insert into tablea(fielda)values('6');<wbr />
</div>


insert into tablea(fielda)values('1');
insert into tablea(fielda)values('2');
insert into tablea(fielda)values('3');
insert into tablea(fielda)values('4');
insert into tablea(fielda)values('5');
insert into tablea(fielda)values('6');

<div>
<div class="content wysiwyg-content">
folks<br />
<br />
how do I load batch data (100s of inserts) at once using the oracle sql developer tool?<br />
<br />
i was force to lelave my beloved toad behind and am a little stuck<br />
<br />
all pointers will be much appreciated<br />
r
</div>
</div>


folks

how do I load batch data (100s of inserts) at once using the oracle sql developer tool?

i was force to lelave my beloved toad behind and am a little stuck

all pointers will be much appreciated
r

oracle, sql developer, 10.2.0.3, loading batch inserts using oracle sql developer

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.