Answers for "oracle sql developer print to console"

SQL
17

oracle output to console

-- SQL Developer :  show View | DBMS Output > Add connection (+)
SET SERVEROUTPUT ON;
DECLARE
	v_name VARCHAR2(50) := 'Bond';
BEGIN
	DBMS_OUTPUT.PUT_LINE('Hello !');
	DBMS_OUTPUT.PUT_LINE('My name is ' || v_name);
END;
Posted by: Guest on July-10-2021
0

oracle sql log to console

set serveroutput on format wrapped;
begin
    DBMS_OUTPUT.put_line('simple comment');
end;
/

-- do something

begin
    DBMS_OUTPUT.put_line('second simple comment');
end;
/
Posted by: Guest on March-12-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language