In this tutorial, we will introduce you to PL/SQL language and discuss PL/SQL history, the language elements and the advantages that PL/SQL brings to the Oracle development.
PL/SQL is a Procedural Language (PL) that extends the Structured Query Language (SQL). If you have been programming Pascal or Ada, you will find much familiar syntax in PL/SQL.
It is difficult to write applications using SQL only because each SQL statement runs independently and has little or no effect on each other. To overcome this limitation, you often have to use other programming languages such as C/C++, Perl, PHP, and Java, by using standard database interfaces. Oracle supports this approach when you want to develop applications that interact with Oracle databases.
PL/SQL is not case sensitive so you are free to use lower case letters or upper case letters except within string and character literals. A line of PL/SQL text contains groups of characters known as lexical units. It can be classified as follows:
- Delimeters
- Identifiers
- Literals
- Comments
0 comments:
Post a Comment