Lab 2.2 PL/SQL in SQL*Plus
After this Lab, you will be able to:
SQL*Plus is an interactive tool that allows you to type SQL or PL/SQL statements at the command prompt. These statements are then sent to the database. Once they are processed, the results are sent back from the database and displayed on the screen. However, there are some differences between entering SQL and PL/SQL statements.
Consider the following example of a SQL statement.
▪ FOR EXAMPLE
SELECT first_name, last_name FROM student;
The semicolon terminates this SELECT statement. Therefore, as soon as you type the semicolon and hit the ENTER key, the result set is displayed to you.