PL%2FSQL is an actively used programming language created in 1991. 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%2FSQL ranks in the top 5% of languages
- the PL%2FSQL wikipedia page
- PL%2FSQL first appeared in 1991
- file extensions for PL%2FSQL include pls, bdy, ddl, fnc, pck, pkb, pks, plb, plsql, prc, spc, sql, tpb, tps, trg and vw
- See also: sql, transact-sql, postgresql, plpgsql, sql-psm, object-pascal, free-pascal, java, sqlite, sqlpl
- I have 81 facts about PL%2FSQL. what would you like to know? email me and let me know how I can help.
Example code 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 code 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 code 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;
Last updated July 22nd, 2019