Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Could someone let me know what is the purpose of using set serveroutput on/off in oracle?

I ran the below query to see what it is doing. However I need to know much about serveroutput. Kindly help me

 set serveroutput on;
     select * from tab;
    select * from tab;
     select * from tab;
     set serveroutput off;
share|improve this question

closed as off-topic by a_horse_with_no_name, RolandoMySQLDBA, Mark Storey-Smith, Max Vernon, Michael - sqlbot Oct 23 '13 at 11:55

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – RolandoMySQLDBA, Michael - sqlbot
If this question can be reworded to fit the rules in the help center, please edit the question.

set serveroutput [on|off] is used to enable or disable the output made by the DBMS_OUTPUT package, for example in sql*Plus; in your example, it has no effect. – Nicolas Durand Oct 22 '13 at 13:09
Thank you Nicolas :) Any weblinks which will give more information would be much beneficial. However Now I understood the purpose of set serveroutput. Thanks a lot – user3475 Oct 22 '13 at 13:39
Oracle 11.2 SQLPlus Reference:… – MGS Oct 22 '13 at 14:24

1 Answer 1

set serveroutput on executed in SQL Plus executes behind the scenes:

dbms_output.enable(buffer_size => NULL);

set serveroutput off executes:

share|improve this answer
Thanks phill...makes sense thanks a lot – user3475 Oct 22 '13 at 18:55

Not the answer you're looking for? Browse other questions tagged or ask your own question.