Languages Features Creators CSV Resources Challenges Add Language
GitHub icon


PL/SQL - Programming language

< >

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...

Example from hello-world:
BEGIN dbms_output.put_line('Hello World'); END; /
-- 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 Token Example
Strings '
'Hello world'
Print() Debugging dbms_output.put_line
-- A comment
Line Comments --
-- A comment
Semantic Indentation X

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
bcpl.html · pl-sql.html · processing.html

View source

- Build the next great programming language · Search · Day 212 · About · Blog · Acknowledgements · Traffic · Traffic Today · GitHub ·