PL/SQL

PL/SQL is a programming language created in 1991.

#148on PLDB	32Years Old	2.4kUsers
5Books	0Papers	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...

PL/SQL Wikipedia page
PL/SQL docs
There are at least 20,365 PL/SQL repos on GitHub
PL/SQL first developed in Oracle
PLDB estimates there are currently 3k job openings for PL/SQL programmers.
file extensions for PL/SQL include pls, bdy, ddl, fnc, pck, pkb, pks, plb, plsql, prc, spc, sql, tpb, tps, trg and vw
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
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
HTML of this page generated by LanguagePage.ts

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;

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

title	author	year	reviews	ratings	rating
Advanced Plsql Programming: The Definitive Reference	Boobal Ganesan		0	0	0.0
Oracle SQL: Sql-Plsql Concepts, Queries & Tips for All Database Developers & Programmers	Niraj Gupta		1	0	0.0
100 Plus SQL and PLSQL Tips: Useful for Beginner's and Experienced Database Programmers and Developers	Niraj Gupta	2014	0	5	4.00
Data-Centric Programming Languages: Mumps, Microsoft Access, Plsql, Transact-SQL, IBM RPG, Visual FoxPro, Jade, K	Source Wikipedia		0	0	0.0
Oracle: Oracle Adf, Sun Microsystems, Plsql, Oracle Rac, Larry Ellison, Jdeveloper, BMW Oracle Racing, SQL Developer	Quelle Wikipedia		0	0	0.0

PL/SQL - Programming language

Language features

Books about PL/SQL on goodreads