How to enable DBMS_OUTPUT in SQL Developer? [duplicate]

Question

output for below code

DECLARE

a int;

b int;

c int;

BEGIN

a:=&a;

b:=&b;

c:=a+b;

dbms_output.put_line('Sum of a and b is '||c);

end;

/

Answer 1

In SQL Developer you have to

1. Show the DBMS_OUTPUT pane using View > DBMS_OUTPUT.

2. Enable it by pressing the green "+" symbol in the output pane.

For more details including how to have dbms_output enabled by default for all sessions, see www.thatjeffsmith.com/archive/2012/05/enabling-dbms_output-by-default-in-sql-developer

Step by step instructions from Jeff Smith's post:

• Open a new worksheet.
• Code this line:
  set serverout on
• Save to 'startup.sql' in some convenient folder
• Open Tools > Preferences
• Go to the Database page
• On the 'Filename for connection startup script' – point to the 'startup.sql' file you just created.
• Restart SQL Developer.
• Open a connection and run your code.