Procedural Language/Structured Query Language (PL/SQL)
Advertisement
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.Related Question
What are the biggest uses of SQL today?Advertisement
Synonyms
Procedural Language/SQL
Related Terms
Related Reading
- Computer Programming for the People?
- 5 Things You Need to Know About HTML5
- Functional Programming Languages: Past, Present and Future
- Online Learning: How to Master these 6 Key Data Science Concepts
- Online Learning: 10 Essential Computer Science Courses
- INFOGRAPHIC: The History of Programming Languages