Top 1,000 Features Creators Events Podcasts Extensions Blog Explorer CSV Download

PL/SQL

< >

PL/SQL is a programming language created in 1991.

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


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 Example Token
Booleans TRUE FALSE
Strings
'Hello world'
'
Print() Debugging dbms_output.put_line
Comments
-- A comment
Line Comments
-- A comment
--
Semantic Indentation X

View source

- Build the next great programming language · About · Resources · Acknowledgements · Part of the World Wide Scroll