The Execution section of a PL/SQL Block starts with the reserved keyword BEGIN and ends with END. Cursors are also declared in this section.
Placeholders may be any of Variables, Constants and Records, which stores data temporarily. This section is optional and is used to declare any placeholders like variables, constants, records and cursors, which are used to manipulate data in the execution section. The Declaration section of a PL/SQL Block starts with the reserved keyword DECLARE. The Exception Handling (or Error) section (optional).Lets share our knowledge about PL SQL with others.Įach PL/SQL program consists of SQL and PL/SQL statements which from a PL/SQL block. This PL/SQL tutorial will be growing regularly let us know if any topic related to PL SQL needs to be added or you can also share your knowledge on PL SQL with us. The concepts like cursors, functions and stored procedures can be used in other database systems like Sybase, Microsoft SQL server etc, with some change in SQL syntax. I will be making more Oracle PL SQL programming tutorials as often as possible to share my knowledge in PL SQL and help you in learning PL SQL language and syntax better.Įven though the programming concepts discussed in this tutorial are specific to Oracle PL SQL. You can use these free online tutorials as your guide to practice, learn, for training, or reference while programming with PL SQL. This Oracle PL SQL tutorial teaches you the basics of database programming in PL/SQL with appropriate PL/SQL tutorials with coding examples.
A PL/SQL language code can be stored in the client system (client-side) or in the database (server-side). Oracle uses a PL/SQL engine to processes the PL/SQL statements. It was developed by Oracle Corporation in the early 90’s to enhance the capabilities of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. PL/SQL stands for Procedural Language extension of SQL.