PL/SQL - Programming language

PL/SQL is a programming language created in 1991.

#218on PLDB

33Years Old

20kRepos

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored pl/sql procedures/functions/packages/triggers since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. Read more on Wikipedia...

Tags: programming language
There are at least 20,365 PL/SQL repos on GitHub
Early development of PL/SQL happened in Oracle
The Google BigQuery Public Dataset GitHub snapshot shows 6k users using PL/SQL in 7k repos on GitHub
Check out the 276 PL/SQL meetup groups on Meetup.com.
PL/SQL on HOPL
PL/SQL ranks #18 in the TIOBE Index
ANTLR grammar for PL/SQL
GitHub supports syntax highlighting for PL/SQL
Learn PL/SQL on exercism.
Indeed.com has 2,972 matches for "pl/sql developer".
See also: (10 related languages) SQL, Transact-SQL, PostgreSQL, PL/pgSQL, SQL/PSM, Object Pascal, Free Pascal, Java, SQLite, SQLPL

Example from hello-world:

BEGIN
  dbms_output.put_line('Hello World');
END;
/

Example from the Hello World Collection:

-- Hello World in Oracle PL/SQL (sqlplus)

set serveroutput on

begin
  dbms_output.enable(10000);
  dbms_output.put_line('Hello World');
end;
/

Example from Linguist:

create or replace procedure print_bool(
    p_bool in BOOLEAN,
    p_true_value in varchar2 default 'TRUE',
    p_false_value in varchar2 := 'FALSE'
)
as
begin

    dbms_output.put_line(case when p_bool then p_true_value else p_false_value end);

end print_bool;
/

Example from Wikipedia:

DECLARE
  CURSOR cursor_person IS
    SELECT person_code FROM people_table;
BEGIN
  FOR RecordIndex IN cursor_person
  LOOP
    DBMS_OUTPUT.PUT_LINE(recordIndex.person_code);
  END LOOP;
END;

Language features

Feature	Supported	Example	Token
Booleans	✓		TRUE FALSE
Strings	✓	'Hello world'	'
Print() Debugging	✓		dbms_output.put_line
Comments	✓	-- A comment
Line Comments	✓	-- A comment	--
Semantic Indentation	X