Update/Delete in a SQL Window

[Genachescu]

Hello,

I'm new to PL/SQL Developer and have a question.
Can I execute an update/delete statement (with commit) in a SQL Window and be able to see the results of the command in output tab for example?
I have been trying, but it doesn't show me anything.

What do you recommend to use for such statements? It is important to see the log and be able to copy it as proof.

Regards,

 

[Marco Kalter]

The SQL Window will display the results, but it does not log your commands.

You can use the Command Window to execute statements with logging. You can use the SET ECHO ON and SET SPOOL commands, just like in SQL*Plus:

SET ECHO ON
SPOOL C:\Temp\Spool.txt
UPDATE dept SET dname = upper(dname);
UPDATE dept SET loc = upper(loc);
SPOOL OFF
HOST notepad C:\Temp\Spool.txt

 

[Genachescu]

Thanks Marco