0

How can I run PL/SQL or SQL from within UltraEdit?

Current I am able to compile the current file like this:

sqlplus database/database@pass @%F

The above compiles, but what is the command to run?

I do not see a show option here:

Enter image description here

Peter Mortensen
  • 30,738
  • 21
  • 105
  • 131
Noman
  • 887
  • 1
  • 15
  • 34
  • How do you run pl/sql from command line? The same command can be used in a user tool in UltraEdit where only the file name is replaced by the placeholder __%f__. (Lower case %f means long file name, upper case %F is for 8.3 short file name.) – Mofi Dec 09 '14 at 12:41
  • If your script interacts with user via keyboard/console window, check the option _Show DOS box_ on __Output__ tab of the user tool configuration. Then you can enter something on prompt. _Capture output_ should not be checked in this case. – Mofi Dec 10 '14 at 07:12

1 Answers1

0
sqlplus apps/apps@dev @%F

The above runs the contents of the file. The file should be saved as .sql.

Noman
  • 887
  • 1
  • 15
  • 34