Running 2 SQL developers, how to default to PL/SQL Developer

[dw12345]

I run scheduled tasks each night that run command files which run SQL in Golden, another SQL query tool. We're switching to PL/SQL developer, but for a short time I'll have Golden and PL/SQL installed. How do I run SQL from a command file in PL/SQL and not Golden?

Below is a line from the command file.

@sqlplus LoginID/Password@schema @sql_code.sql

 

[Marco Kalter]

I'm not quite sure what you mean. If you want to run a script in PL/SQL Developer, then you run PL/SQL Developer. For example:

plsqldev.exe userid=scott/tiger@chicago commandfile="u:\sql scripts\demo_build.sql"

See also chapter 33.4 in the User's Guide.

 

[dw12345]

The script is run from the command file and I don't know which developer the command file will open.

 

[Marco Kalter]

What kind of command file is this?

 

[William Robertson]

From your example, the command script appears to specify SQL*Plus (sqlplus.exe) and not Golden.

 

[dw12345]

A notepad file is saved as .cmd. It is sql plus, but runs in Golden. Currently, Golden is the only developer on the computer, but will have both Golden and PL/SQL for a while.