9.1. A Hello World Program
The text in this session includes screen ouput from SQL*Plus sessions. Refer to Chapter 2 for hints and use of SQL*Plus commands. The following table lists the common SQL*Plus commands used in this chapter.
| SQL*Plus command | Description |
|---|---|
| SAVE filename | Saves the SQL*Plus buffer to a file with an SQL extension |
| @filename | Sends the file to Oracle for compile/execution. You do not need to type the “.SQL” extension. |
| SET SERVEROUTPUT ON | Sets up DBMS_OUTPUT to flush the buffer to the screen. |
| / | Sends the SQL*Plus buffer to Oracle for compile/execution. |
From SQL*Plus, type the following Hello World program. First, type the SQL*Plus command SET SERVEROUTPUT ON, then the procedure text. The last line is a forward slash—this is SQL*Plus and ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
