how to execute multiple insert statements in sql developer 1.2.1

oracle sql developer seems not to allow multiple insert statements to be executed at once.

can please someone teach me how can this be done, if at all can be possible?

right now i am running only 88 statements manually, but that number can increase to over 500.
sampleFile.TXT
itortuAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Check out:
http://searchoracle.techtarget.com/feature/How-to-use-SQL-Developer-to-run-SQL-statements

How to enter and execute a SQL script

A SQL script is a file that contains one or more SQL statements.
0
 
paquicubaConnect With a Mentor Commented:
To run all statements on your Worksheet press:  F5

To run one single statement, place your cursor on the target statement and press: F9
- statements must separated by ";" or "/"
- If statements are not separated by ";" or "/" then you must highlight the whole statement.

To run an Explain Plan press: F10

To run Autotrace press: F6
0
 
itortuAuthor Commented:
Thank you guys, both.

By the way, do you have any links to samples or code examples on how this can be done programmatically?
0
 
paquicubaCommented:
Using SQL Developer? I haven't seen that. You can for sure achieve it using SQL*Plus...
0
 
itortuAuthor Commented:
can it be done using pl/ sql? in sql developer?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.