# PL/SQL

> One of the technologies in Oracle Database, a programming language that combines SQL syntax

**Wikidata**: [Q41574](https://www.wikidata.org/wiki/Q41574)  
**Wikipedia**: [English](https://en.wikipedia.org/wiki/PL/SQL)  
**Source**: https://4ort.xyz/entity/pl-sql

## Summary
PL/SQL (Procedural Language/Structured Query Language) is a programming language developed by Oracle Corporation. It is a core technology within Oracle Database, distinguished by its ability to combine SQL syntax with procedural programming capabilities.

## Key Facts
*   PL/SQL is owned by Oracle Corporation.
*   It was incepted in 1992.
*   PL/SQL is an instance of a programming language.
*   It employs a procedural programming paradigm.
*   The language incorporates SQL query syntax as a component.
*   Its official website is `http://www.oracle.com/technology/tech/pl_sql/index.html`.
*   PL/SQL is also known by aliases such as Procedural Language/Structured Query Language, PL-SQL, and Oracle PL/SQL.
*   It has 34 sitelinks across various platforms.

## FAQs
### Q: What is PL/SQL?
A: PL/SQL is a programming language that is one of the technologies in Oracle Database. It is notable for combining SQL syntax with procedural programming.

### Q: Who owns PL/SQL?
A: PL/SQL is owned by Oracle Corporation.

### Q: When was PL/SQL created?
A: PL/SQL was incepted in 1992.

### Q: What type of programming does PL/SQL use?
A: PL/SQL is an instance of a programming language that uses a procedural programming paradigm.

### Q: What does PL/SQL combine?
A: PL/SQL combines SQL query syntax within its programming language structure.

## Why It Matters
PL/SQL is significant as a foundational programming language within the Oracle Database ecosystem. Its unique ability to combine SQL syntax with procedural programming allows developers to embed complex logic directly into database operations. This integration facilitates more powerful and efficient data processing and application development within the Oracle environment, making it a key technology for those working with Oracle Database.

## Notable For
*   Being a native programming language for the Oracle Database.
*   Its unique combination of SQL syntax with procedural programming.
*   Its development and ownership by Oracle Corporation.
*   Its inception in 1992.

## Body
### Definition and Classification
PL/SQL, which stands for Procedural Language/Structured Query Language, is a programming language. It is classified as an instance of a programming language and adheres to a procedural programming paradigm. Its core characteristic is the combination of SQL syntax within its programming structure, specifically incorporating SQL query capabilities.

### History and Ownership
PL/SQL was incepted in 1992. It is owned by Oracle Corporation, a prominent technology company.

### Technical Characteristics
As a procedural programming language, PL/SQL allows for the execution of code blocks, control structures, and subprograms. A key feature is its integration with SQL, enabling direct interaction with the Oracle Database for data manipulation and retrieval.

### File Formats
PL/SQL supports various readable and writable file formats, including:
*   PL/SQL source file
*   PL/SQL binary
*   Package source file
*   Package binary file
*   Combined package specification plus body file

### Identifiers and Aliases
PL/SQL is known by several aliases, including:
*   Procedural Language/Structured Query Language
*   PL-SQL
*   PL SQL
*   程序上的语言/结构化查询语言
*   Oracle PL/SQL
*   PLSQL

It has various unique identifiers across different knowledge bases:
*   GND ID: 4457669-9
*   Freebase ID: /m/0609p
*   Quora Topic: PL-SQL
*   NL CR Aut ID: ph249440 (with qualifier 'PL/SQL (programovací jazyk)')
*   Yale LUX ID: concept/8843b78b-c048-48fd-bf41-2e5d78bfbd25
*   GitLab Topic ID: PL-SQL, PL%252FSQL
*   Library of Congress Authority ID: sh96008008
*   National Library of Israel J9U ID: 987007561375705171
*   Bibliothèque Nationale de France ID: 135115170
*   Microsoft Academic ID (discontinued): 32145003
*   National Library of Spain SPMABN ID (BNE V1.0): XX544855

### Related Technologies and Concepts
PL/SQL is related to the broader concept of a "programming language." Another related technology is PL/pgSQL, a procedural programming language designed for PostgreSQL database systems, which was incepted in 1998.

### Online Presence
The official website for PL/SQL is `http://www.oracle.com/technology/tech/pl_sql/index.html`, primarily in English. It also has a presence on Stack Exchange with the tag `https://stackoverflow.com/tags/plsql`. Wikipedia hosts articles about PL/SQL in multiple languages, including English, German, Spanish, and French.

## References

1. [Source](https://www.oracle.com/database/technologies/appdev/plsql.html)
2. Freebase Data Dumps. 2013
3. [Source](https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/packages.htm#LNPLS00913)
4. [Source](https://www.orafaq.com/wiki/File_extensions)
5. Quora
6. National Library of Israel