All geek questions in one place

Screen output in Oracle SQL

I have looked in some detail for message output in Oracle SQL. I read a lot about dbms_output.put_line and dbms_output.get_line and tried to use both, but couldn't get them to work. Using Oracle SQL Developer version 2.

+4
source share
1 answer

I'm not sure which application you are using, but in general, to output the DBMS_OUTPUT buffer for your client, you first need to set SET SERVEROUTPUT ON .

See http://www.adp-gmbh.ch/ora/sqlplus/serveroutput.html .

+4
source

Source: https://habr.com/ru/post/1399874/

More articles:


All Articles