I would like make it a stored procedure so I can use an external tool to call it and process it accordingly. Also, I would like multiple rows to be inserted into table B; not just one; so I assume that there would be the need to use variables. Any ideas?
v/r Roy On Apr 28, 3:04 pm, ddf <[email protected]> wrote: > On Apr 28, 2:38 pm, Roy Arellano <[email protected]> wrote: > > > I am trying to create a stored procedure in which I take a select > > statement for multiple rows out of one table and insert them into > > another table when calling this stored procedure. Any suggestions? > > > Goal: > > 1. Create Stored Procedure > > 2. Select Distinct data columns from table A (many rows) > > 3. Insert result set into table B > > > Thanks. > > Why is it 'necessary' to make this a stored procedure? Unless this > is homework a simple insert into ... select ... would be much faster > and easier to implement. > > David Fitzjarrell --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
