Questions Concepts
GitHub icon

PL/SQL

PL/SQL - Programming language

< >

PL/SQL is a programming language created in 1991.

#155on PLDB 32Years 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 Token Example
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 · Search · Add Language · Features · Creators · Resources · About · Blog · Acknowledgements · Queries · Stats · Sponsor · Traffic · Traffic Today · Day 305 · feedback@pldb.com · Logout