Procedural Language/Structured Query Language (PL/SQL)
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.
Survey: Why Is There Still a Gender Gap in Tech?
Do you work in the tech industry? Help us learn more about why the gender gap still exists in tech by taking this quick survey! Survey respondents will also be entered to win a $100 Amazon Gift Card!
- 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