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

28Years Old 81,089Users 1,283Jobs

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;

Trending Repos

repo stars description

Last updated October 20th, 2019