Block structure, nested block structure.PL/SQL language features include the following elements: If you are programming in other languages, you can get familiar with PL/SQL very quickly and understand the intent of the code without difficulty. PL/SQL provides a very expressive syntax that makes it easy for anyone who wants to learn PL/SQL. PL/SQL Advantages PL/SQL is a highly structured language Since then many features have been added to PL/SQL such as XML support, preprocessor, file I/O, object-orientation, new statements such as CONTINUE and GOTO to make it one of the most highly structured programming languages.
#Pl sql developer portable upgrade#
Since version 7, Oracle did a major upgrade for PL/SQL (version 2.0) that provides more features such as procedures, functions, packages, records, collections, and some package extensions. Oracle introduced PL/SQL (version 1.0) in its Oracle Database product version 6.0 as the scripting language in SQL*Plus and programming language in SQL*Forms 3.
![pl sql developer portable pl sql developer portable](https://s1.o7planning.com/vi/10255/images/30230.png)
![pl sql developer portable pl sql developer portable](https://i.stack.imgur.com/g3Znw.png)
In addition, Oracle also encourages you to use PL/SQL to work with Oracle databases because PL/SQL brings many advantages. Oracle supports this approach when you want to develop applications that interact with Oracle databases. 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. It is difficult to write applications using SQL only because each SQL statement runs independently and has little or no effect on the other. If you have been programming Pascal or Ada, you will find much familiar syntax in PL/SQL. PL/SQL is a Procedural Language (PL) that extends the Structured Query Language (SQL). Summary: 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.