Re: Help with query strategy for view on table
I agree. Unfortunately the data is written into the tables from a PLC that doesn't have the ability to query and update, only insert rows.
You've got me thinking about using a trigger now. I can't control what goes in that table, but I can make a new table that holds the data in the way you describe and contains the logic necessary to match those values up, instead of a view.
Subject
Views
Written By
Posted
569
January 15, 2019 04:36PM
285
January 15, 2019 07:00PM
Re: Help with query strategy for view on table
303
January 16, 2019 09:54AM
267
January 16, 2019 10:29AM
261
January 17, 2019 09:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.