PLDB
Languages Features Calendar CSV Lists Blog About Sponsor Add Language
GitHub icon

PL/SQL

PL/SQL

PL/SQL is a pl created in 1991.

#170on PLDB 31Years 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...


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 ϴ

Books about PL/SQL on goodreads

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
sparc.html · pl-sql.html · limbo.html

View source

PLDB - Build the next great programming language · v2022 · Day 31 · Docs · Build · Acknowledgements · Traffic Today · Traffic Trends · Mirrors · GitHub · feedback@pldb.com