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
