Re: Create a Trigger for an existing View

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 11 Apr 2007 11:44:10 -0700
Message-ID: <1176317050.102633.22260@n59g2000hsh.googlegroups.com>

On Apr 10, 5:47 pm, "Dean Tomasevic" <dean.tomase..._at_googlemail.com> wrote:

> The Task:
> "Please write a inner join for the tables DEMO_USERS and DEMO_ORDERS.
> The required information are the USER_ID and ORDER_ID.
> If anybody take a new order you must be able to see it in your result,
> but
> don't use a view!
> Try it with a inner join and a trigger."

It's not a clear specification.

To me, it sounds like one possible way to "guess" what is being asked would be to write a trigger on DEMO_ORDERS.

For each new row in DEMO_ORDERS the trigger "might be supposed to" check the DEMO_USERS table and if there is not a row with the correct USER_ID in DEMO_USERS, do an insert into DEMO_USERS.

I think you should ask some more questions about this assignment personally.

What does the output of a DESCribe on those 2 tables look like? Received on Wed Apr 11 2007 - 13:44:10 CDT