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
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.