Oracle SQL/PLSQL Section 2.6: About PL/SQL
PL/SQL stands for Procedural Language extensions to SQL. PL/SQL is available only as an "enabling technology"
within other software products; it does not exist as a standalone language. You can use PL/SQL in the Oracle
relational database, in the Oracle Server, and in client-side application development tools, such as Oracle Forms.
Here are some of the ways you might use PL/SQL:
- To build stored procedures.
- To create database triggers.
- To implement client-side logic in your Oracle Forms application.
- To link a World Wide Web home page to an Oracle database.
An example of an anonymous block
set serveroutput on;
DECLARE-- declare a variable message
message VARCHAR2(20);
BEGIN
message := 'HELLO WORLD';-- assign value to variable
DBMS_OUTPUT.PUT_LINE(message); -- print message to screen
END;
0 Comments