PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL's language syntax structure and datatypes are similar to that of ADA. The language includes object oriented programming techniques such as encapsulation function overloading information hiding (all but inheritance) and so brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.
PL/SQL is Procedural Language extension to SQL. PL/SQL's language syntax structure and datatypes are similar to that of ADA. The language includes object oriented programming techniques such as encapsulation function overloading information hiding (all but inheritance) and so brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.
PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database.
New Term - If you have worked with relational databases in the past you are no doubt familiar with SQL which stands for Structured Query Language. SQL itself is a powerful declarative language. It is declarative in the sense that you describe the results that you want but not how they are obtained. This is good because you can insulate an application from the specifics of how the data is physically stored. A competent SQL programmer can also push a great deal of processing work back to the server level through the creative use of SQL.
PL SQL is a block structured programming language. It combines data manipulation & data processing power. It supports all SQL data types. Also has its own data types i e BOOLEAN BINARY INTEGER
PL/SQL is the procedural extension to SQL with design features of programming languages. Data manipulation and query statements of SQL are included within procedural units of code. PL/SQL offers modern software engineering features such as data encapsulation exception handling information hiding object orientation.
PL/SQL stands for procedural languages extensions to SQL and it's theme is to hold a bunch of SQL statements as a single function and return a single output. PL/SQL is advantageous compared to other programming languages as it is a Oracle proprietary and does not require any external interfaces for the database connectivity.
