Answers for "oracle stored procedure print output"

SQL
17

how to get output from stored procedure in oracle

-- 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

Code answers related to "oracle stored procedure print output"

Code answers related to "SQL"

Browse Popular Code Answers by Language