Re: insertion using stored procedure in oracle.

ad wrote:
> hi there,
> I need to write to a stored procedure in oracle 9i to insert values in
> a table in which:
> 1) Values in one column are to be retrived from a column in another
> table.
> 2)Getting three parameters as inputs in the procedure,and inserting
> those values in the same row which has the value that has been taken
> from the different table.
>
> am very new to sp and am really confused when do we use wat..like
> cursors,index,functions etc.
> so plzz provide some sample code to handle this insertion.

Then take a class.

You don't seriously think anyone is going to turn you into a PL/SQL developer with a few quick paragraphs in a usenet group I hope.

Not trying to be difficult here but you are pretty much asking for someone to teach you how to do a job for which you are totally unqualified.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)