Answers for "oracle print variable 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

dbms_output sql developer

SET SERVEROUTPUT ON
BEGIN
 Dbms_Output.Put_Line(Systimestamp);
END;
Posted by: Guest on May-28-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language