Clearing the Script Output Buffer in Oracle SQL Developer

thatjeffsmith SQL Developer 4 Comments

Tell Others About This Story:

Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block?

Quick Answer: CLEAR SCREEN [Oracle Docs]

SQL Developer supports many, and soon to be ALL, SQL*Plus commands. CLEAR is one of them. So just add this to the top of your script. When you execute your script, the Output Panel will clear.

CLEAR SCREEN command support in Oracle SQL Developer

CLEAR SCREEN command support in Oracle SQL Developer

You’ll see there’s the output from the previous run, then we execute, and then we scroll back up the buffer – the previous execution output is gone.

If you’re curious about what all SQL*Plus commands we support, check out the the Help Topic on the subject:

Supported SQL*Plus Commands in Oracle SQL Developer

Supported SQL*Plus Commands in Oracle SQL Developer

So, if you like the /*csv*/ script output ‘trick’ in SQL Developer, you can use the good ole SQL*Plus SPOOL command to write that output to your CSV file automagically as well.

Just remember, for the SQL*Plus engine to be invoked in SQL Developer – use the ‘Run Script’ or F5 button on the Worksheet toolbar:

This one!

This one!

Tell Others About This Story:

Comments 4

  1. Your answer doesn’t answer the question 🙂 Please note that “DBMS output” window is different to “Script output” window. Question was:

    “Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block?”

    I see there are 2 options available: shortcut key and mouse click on clear. But not command (I’m OK with that).

    1. But you can’t use CLEAR short-cut keys from code editor window (where usually user is located), which make it not very usable. So any other option how to clear “DBMS output” window from code editor window?

    2. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *