I am new to writing stored procedures in oracle and was looking for someone to help me. I have a process that I have to run every month and the only thing that changes is one table (ie AdHoc111). So what I wanted to do is pass the paramater as the table name and then have the results put into 6 different tables. So all i would have to do is execute sp (Adhoc111). Also each time it was run it would clear the results tables. I am attaching the steps I am using currently. Any Help would be great
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.