I have a stream that updates every minute with a trigger that updates
another table with information from the stream. That way I'm constantly
updated with no need to run a script to update before I want a report.
Clifford
On Sun, Oct 1, 2017 at 10:08 AM, Melvin Davidson
wrote:
>
>
> On Sun, Oct
Thank you for your suggestion which solved the problem. Much better
solution that what I was trying to accomplish. Much smaller table to query
since it only has one entry per user.
Clifford
On Wed, Dec 28, 2016 at 8:12 PM, Adrian Klaver
wrote:
> On 12/28/2016 07:06 PM, Clifford Snow wr
I'm trying to write a trigger (my first) to update another table if the
user_id is new. But I'm getting a index exception that the user_id already
exists. I'm picking up data from another feed which gives provides me with
changes to the main database.
what I have is
CREATE OR REPLACE FUNCTION add
