Oracle PL/SQL - Maintenance routines

  • Posted:
  • Proposals: 2
  • Remote
  • #46820
  • Archived
Sohail N.Angela S. have already sent a proposal.
  • 0


Experience Level: Expert
We have data in spreadsheets that need to be loaded into tables then used to maintain a few tables.

There are two spreadsheets which look like this...

Spreadsheet 1 has two columns like this...

From this spreadsheet data we need to ensure our table checks to see whether MENU1 exists and if not, it adds it to the table.

It then needs to make sure ROLE1, ROLE2 and ROLE3 have access to MENU1. If it doesn\'t it should add them. If MENU1 currently has more roles than shown, a warning message should be displayed.

This is the first part of the process - checking that the menu structure specified is in place. The next part of the process is making sure reports are attached to the correct menu.

Spreadsheet 2 has two columns too.
source_report target_report

Source report is in the format MENU1->MENU2->REPORT1
target report is in the same format but may have a different report name e.g. MENU3->MENU4->REPORT8

This routine is letting our staff specify reports they want copied to other menus and often with other names. Essentially the system is supplied with standard reports and we would love to have virtual folders so that users could pick and choose reports of importance to them but this feature is not available.

Therefore, the next best thing is to copy the existing reports into a more user-friendly report structure. We want to automate this task with these routines so that when upgrades happen, we can re-run this routine to copy the updated reports to the appropriate places.

Clearly I will need to supply table structures and sample spreadsheets but hopefully this is enough to get us started.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.