PL/SQL

PL/SQL is a programming language created in 1991.

#155on 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...

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

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

PL/SQL - Programming language

Language features