vide value for
> > NAME when
> > updating this record.
> >
> > >From: Jeff Eckermann <[EMAIL PROTECTED]>
> > >To: Bernard Cheung <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED]
> > >Subject: Re: [SQL] Trigger function to know which fields are be
s not changing, this will not tell
you anything, even if the user is in fact supplying
the name.
Depending on what rules you want to enforce, you may
be better off doing the checking in your application.
>
> >From: Jeff Eckermann <[EMAIL PROTECTED]>
> >To: Bernard Cheung <[
ADDRESS = '123 Drive' WHERE COMPANY_ID = 1;
I want the trigger to ensure that the user must provide value for NAME when
updating this record.
From: Jeff Eckermann <[EMAIL PROTECTED]>
To: Bernard Cheung <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: [SQL] Trigger function t
--- Bernard Cheung <[EMAIL PROTECTED]> wrote:
> I am writing a trigger function. How can I know
> which fields are being
> updated in the PL/SQL function?
>
> For example I have a table here:
>
>
> CREATE TABLE COMPANY (
> COMPANY_ID VARCHAR(10) NOT NULL,
> NAME VARCHAR(30),
> ADDRESS VA
I am writing a trigger function. How can I know which fields are being
updated in the PL/SQL function?
For example I have a table here:
CREATE TABLE COMPANY (
COMPANY_ID VARCHAR(10) NOT NULL,
NAME VARCHAR(30),
ADDRESS VARCHAR(30));
I want to write a trigger to block all update statements with
