Re: INSERT a number in a column based on other columns OLD INSERTs

On 06/20/2015 12:41 PM, Charles Clavadetscher wrote:
> Hello
>
> I just made a short test with the code provided. As Bill mentioned the
> moment when the trigger is fired is essential.
> I made a test with both before (worked) and after (did not work because
> the row was already inserted and the returned new row is ignored).
>
> The assignment (= or :=) does not seem to play a role, but the correct
> version is as mentioned :=

Yea, I can't seem to remember this part of the docs:

" Equal (=) can be used instead of PL/SQL-compliant :=."

>
> Bye
> Charles
>


--
Adrian Klaver
adrian.klaver@aklaver.com