ALERT

[LAST CHANCE] Data Layer: Modern Business, Defined

Procedural Language/Structured Query Language (PL/SQL)

Definition - What does Procedural Language/Structured Query Language (PL/SQL) mean?

Procedural language/structured query language (PL/SQL) is Oracle’s implementation of a structured query language (SQL) programming language extension. PL/SQL is a powerful tool that combines SQL’s querying ability with the added bonus of programming features.

Techopedia explains Procedural Language/Structured Query Language (PL/SQL)

Beginning with Oracle7 in the early 1990s, Oracle first developed and offered PL/SQL. Since that time, PL/SQL has been included wherever SQL is offered. A separate Oracle PL/SQL engine inside the software is used to process the PL/SQL code. Like SQL, PL/SQL follows a strict syntax-controlling structure. The PL/SQL code block consists of three main sections: Declaration (optional): Declaration section introduction keyword is DECLARE. Execution (mandatory): Main execution section introduction keyword is BEGIN. Exception (optional): Exception handling section introduction keyword is EXCEPTION. Thus, the layout appearance is structured as follows: DECLARE declaration_section BEGIN Program_execution EXCEPTION Exception_handling Objects created only by using PL/SQL, rather than purely SQL, include functions, packages and procedures. However, most applications that run SQL code also support PL/SQL. Thus, database administrators and developers rarely separate SQL and PL/SQL code.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.