Mark D Powell wrote:
> This sounds like a homework assignment and homework should be done by
> the person it is assinged to.
>
> You can find examples of everything you need in the PL/SQL manaul. The
> manuals are available via
> http://www.oracle.com/technology/documentation/index.html
>
>>From your description I am not sure if you need to insert all the rows
> from one table into another or only the row that match the input
> parameters but you need to look up the following:
>
> create or replace procedure
> cursor
> Loop
> IF
>
> Some examples:
> procedure compare_struct (
> p_db1 in varchar2
> ,p_db2 in varchar2
> ) is
> --
>
> cursor c_drv is
> select distinct
> owner
> ,table_name
> from
> compare_struct cs
> where cs.database = v_db1;
> --
> r_drv c_drv%rowtype;
>
> HTH -- Mark D Powell --
A Cursor? If he is starting out why not direct him straight to
bulk binding?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Oct 18 2005 - 17:59:35 CDT
