Re: Compilation errors in TRIGGER

Dana Reed wrote:

> You wrote ":new.id" in your original post and you're asking what it
> means?

Someone else gave me a snippet of code, I just wanted to understand it :-)

> Lookup ":new" and ":old" and you'll see that this syntax can be
> used in triggers to refer to new and old column values in triggers.

Makes sense. I'm having a problem with my browser - it crashes when I get to the triggers page in the docs at technet.oracle.com. I'm not kidding, it crashes just as I get to where I want to be :-(

> "dual" is a weird Oracle pseudo-table that you can select system
> variable values from, like SYSDATE, sequence .NEXTVAL and .CURRVAL,
> etc. If you want to get really confused DESCRIBE dual...

Yep, that's confused me. I'll try not to wonder about dual again ;-)

Thanks for your comments, much appreciated.

• Kev