preview

The History Of PL/SQL

Good Essays
PL/SQL is a combination of SQL along with the procedural features of programming languages.The PL/SQL programming language was developed by Oracle Corporation as procedural extension language for SQL and the Oracle relational database.Some of notable facts about PL/SQL:
• PL/SQL is portable, high-performance transaction processing language.
• PL/SQL provides a built in interpreted as well as OS independent programing environment.
• PL/SQL can directly be called from the command line SQL-Plus interface.
• Direct call can be made from external programming language calls to database.
• PL/SQL's general syntax is based on that of ADA and Pascal programming language.
• Apart from Oracle, PL/SQL is available in TimesTen in-memory database and IBM
…show more content…
A procedure or function is a schema object that consists of a set of SQL statements and other PL/SQL constructs stored in the database and run as a unit to solve a specific problem. The principal benefit of server-side programming is that built-in functionality can be deployed anywhere.

Oracle Database also stores program units written in Java. A Java stored procedure is a Java method published to SQL and stored in the database for general use. You can call existing PL/SQL programs from Java and Java programs from PL/SQL.

Advantages of PL/SQL :
• SQL is the standard database language and PL/SQL is strongly integrated with SQL.
• PL/SQL supports both static and dynamic SQL. Static SQL supports DML operations and transaction control from PL/SQL block. Dynamic SQL is SQL allows embedding DDL statements in PL/SQL blocks.
• PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications.
• PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database.
• PL/SQL saves time on design and debugging by strong features, such as encapsulation, data hiding,exception handling and object-oriented data types.
• Applications written in PL/SQL are fully portable.
• It provides high security
…show more content…
With an installed base of over two million, Toad continues to be the "de facto" standard tool for db development and admin section.

Toad Help and Resources :
Toad is self-diagnosing tool.If you are having some difficulties with Toad that you cannot understand or fix then the Toad Advisor will help you. It offers hints, alerts, and warnings regarding the current state of your Toad installation. If you are in a managed environment, it specifies which features in Toad are managed, and to what extent.
Create and Manage Connections :
This is a general overview of how Toad connects to Oracle databases.
• Troubleshooting: If your previous connections do not display in the db Login window, we have ensure that the Show favorites only and Show selected home only fields in the bottom of the Database Login window are not selected.
 To connect to a db server Toad requires that you have a db client installed on your computer. Client is simply s/w that accesses the database through a n/w. We can have multiple Oracle clients installed on your computer. These locations are also referred to as Oracle homes and you can select which one Toad currently uses on the Database Login
Get Access