Good morning,
Someone tell me I'm nuts.
I have 25 code tables, all with the same format. Their general format is:
key - number
description - varchar2
modified date - date
modified user - varchar2
In my application, the end users need to be able maintain these tables. Ideally, I was looking to have a list item with all of the table names. The end user would click the table name and a tabular form would open, allowing the user to update the table. Since I hate to recreate the wheel, I was looking into a way to create a tabular report based on a collection based on a dynamic selection. This would also mean that the INSERT, UPDATE and DELETE statements would need to be dynamic as well. This idea does not thrill me, especially since I'd need to dig up instructions on creating a tabular report from a collection.
I also thought about creating a view and recreating the view based on the table the user selects. But with the possibility of multiple users modifying data at the same time, probably not a good idea. Not to mention, at present, I don't know what user would need privs to recreate the view. Since I have an issue with this, my DBA might as well.
I also thought about a single view with all of the tables UNIONed together but that view would be non-updatable. Unless there was a different way to build the view.
Any other ideas? Or should I just bite the bullet and start creating individual tabular reports?
And before I forget, we're using Apex 4.2. Yes we know 5.x is available but we're in the middle of 3 or 4 other major projects and we don't have the resources to look at 5.x. Soon, I'm told.
Thanks
Ray Gillfillan
ray.gillfillan@cais.cus.edu