Re: insert values in a table using procedures

From: Mark D Powell <>
Date: Sat, 18 Oct 2008 10:50:02 -0700 (PDT)
Message-ID: <>

On Oct 18, 3:32 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <> a écrit dans le message de news:
> |I have 3 tables i.e.
> |
><snip>> |
> |
> | how insert the values in t1 table using procedure
> Why using a procedure? Just use an insert select.
> Regards
> Michel

Michel is right, unless you have special requriements that you have not specified you do not need to use pl/sql to do the insert. You can use an insert/select statement to insert the result set of your join select right into your report/work table.

If you just want an example of how to code SQL into PL/SQL see the PL/ SQL manual. There are numerous examples in there.

HTH -- Mark D Powell -- Received on Sat Oct 18 2008 - 12:50:02 CDT

Original text of this message