Re: insert values in a table using procedures
Date: Sat, 18 Oct 2008 10:50:02 -0700 (PDT)
Message-ID: <813400e3-6c71-4591-bc73-502c8b57f5cb@q35g2000hsg.googlegroups.com>
On Oct 18, 3:32 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <vgpotnu..._at_gmail.com> a écrit dans le message de news: ba2ce17e-3532-4ec8-92d5-6f13a2185..._at_w39g2000prb.googlegroups.com...
> |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