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;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;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;
/Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
