The PUT_LINE procedure is like the printf function in “C” or the method in Java Note: To see the outputs from stored procedures, type the command SET SERVEROUTPUT ON at the SQL> prompt in SQL*Plus. Now use the PUT_LINE produce to display something Below is one example of a stored procedure block: All statements and blocks in PL/SQL must end with semicolons. A block begins with the BEGIN keyword and ends with the END keyword. The basic PL/SQL programming unit is called a block. Here is an excellent book on Oracle PL/SQL: Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
PL/SQL runs in both the database engine as well as in many of Oracle’s development tools such as Oracle Developer. Procedures (Program Units) are written in the PL/SQL language (Procedural Language), which is proprietary to Oracle.
The Oracle RDBMS has the ability to store procedures within the data dictionary and execute procedures in the RDBMS.
0 kommentar(er)
