Home » SQL & PL/SQL » Client Tools » PL/SQL Developer : how to execute a sql script
PL/SQL Developer : how to execute a sql script [message #434569] Wed, 09 December 2009 14:48 Go to next message
vdurieu
Messages: 4
Registered: December 2009
Junior Member

I develop a serie of sql queries under PL/SQL Developer (script1.sql, script2.sql,...)
I want to run all of them through a single command

within a sql window, I try command like
start script1.sql
exec script1.sql
@script1.sql

I receive a 'command unknow' syntax error

how can I do ?
thanks
Re: PL/SQL Developer : how to execute a sql script [message #434573 is a reply to message #434569] Wed, 09 December 2009 15:05 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know the answer, but I can see that you are potentially dangerous for the database as it seems that you use a tool you don't know.

Is there help available? Did you read it?

If there's any similarity between PL/SQL Developer and TOAD, you'd Open that SQL file (which would then appear in the SQL window and push the Execute statement button.

Otherwise, perhaps you should better run these scripts within SQL*Plus.
Re: PL/SQL Developer : how to execute a sql script [message #434585 is a reply to message #434569] Wed, 09 December 2009 17:01 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
There is both a Command Window and a Script Window.
Previous Topic: Like clause
Next Topic: How to spool the data of a clob or long column
Goto Forum:
  


Current Time: Thu Sep 29 14:09:27 CDT 2016

Total time taken to generate the page: 0.10075 seconds