STORE PROCEDURES:
==================


COPY TABLE
==========

create or replace procedure table_copy(
  GM_tab_from varchar2,
  GM_tab_to   varchar2)
Is

Begin

  execute immediate 'insert into '||GM_tab_to||' (select * from '||GM_tab_from||')';

End;
/

CREATE_INDEX:
=============

Create or replace procedure CREATE_INDEX

As

Begin

Execute immediate 'create index unconn_dept on SP_UNCONN_EXAMPLE(DEPTNO)';

End;

/

DROP_INDEX:
===========
Create or replace procedure DROP_INDEX

As

Begin

Execute immediate 'drop index unconn_dept';

End;

/