Displaying Hello World! to the Screen

   
SQL> --
SQL>
SQL> set serveroutput on
SQL> CREATE OR REPLACE PROCEDURE HELLO AS
  2  BEGIN
  3       DBMS_OUTPUT.PUT_LINE('Hello World! ' ||
  4            TO_CHAR(SYSDATE,'MM-DD-YY HH:MI:SS AM'));
  5  END;
  6  /

Procedure created.

SQL>
SQL>
SQL> --

Related examples in the same category

1.	Call dbms_output.disable
2.	Call dbms_output.put_line to display text message
3.	dbms_output.enable
4.	EXECUTE DBMS_OUTPUT.ENABLE(10000)
5.	dbms_output.put: display text without new line sign
6.	Call dbms_output.new_line to create a new line
7.	DBMS_OUTPUT.GET_LINES
8.	Combine text and number in DBMS_OUTPUT.PUT_LINE
9.	A small buffer
10.	dbms_output.new_line
11.	DBMS_OUTPUT.NEW_LINE: a new line sign
12.	Use DBMS_OUTPUT.PUT_LINE to output clob data
13.	Use DBMS_OUTPUT.PUT_LINE to output the table collection indexed by BINARY_INTEGER
14.	This script demonstrates the DBMS_OUTPUT package
15.	Output Visual line break

Displaying Hello World! to the Screen : dbms_output « System Packages « Oracle PL / SQL

Related examples in the same category