HOW TO WRAP PLSQL CODE IN ORACLE DATABASE

HOW TO WRAP A PL/SQL CODE IN ORACLE DATABASE
============================================
wrap iname=testproc.sql oname=testproc.plb

HOW TO CREATE A PROCEDURE
==========================
create or replace procedure test as
begin
dbms_output.put_line('Welcome to ORACLE DBA');
end;
/

HOW TO CHECK THE CONTENT OF PROCEDURE
========================================
select owner,object_name from dba_objects where object_name like '&object_name';

select text from dba_source where name='&name';

HOW TO EXECUTE A PROCEDURE
==========================
set serveroutput on;

exec test

HOW TO READ A FILE FROM COMMAND PROMPT
======================================

type testproc.sql
type testproc.plb


PL/SQL files extension
=======================

.pls - PL/SQL source
.plb - PL/SQL binary
.pks - Package source or package specification
.pkb - Package binary or package body
.pck - Combined package specification plus body