SQL

oracle pl sql source

select *
from   all_source
where  lower(text) like lower('%Some source%');

oracle pl/sql package

create or replace package test_pkg as
    procedure print (line in varchar);
end test_pkg;

create or replace package body test_pkg as
    procedure print (line in varchar) is
    begin
        DBMS_OUTPUT.PUT_LINE(line);
    end print;
end test_pkg;

begin
    test_pkg.print('Test');
end;