Search code examples
oracle-databaseplsqldatabaseisql

iSQL Plus: print to screen


How do you enable iSQL*Plus terminal to print output to screen?

For instance a simple hello world block:

iSQL plus terminal

Note how "hello world" should be printed to screen, but only confirmation that there were no compilation errors is given.


Solution

  • You need enable dbms outout and set server output on.

    exec dbms_output.enable(1000000);
    

    and on top of your program paste this:

    set serveroutput on