Home » SQL & PL/SQL » SQL & PL/SQL » Can I change the value of certain field in a BEFORE INSERT trigger?
Can I change the value of certain field in a BEFORE INSERT trigger? [message #38746] Fri, 10 May 2002 07:21 Go to next message
vwz
Messages: 1
Registered: May 2002
Junior Member
As title

Report message to a moderator

Re: Can I change the value of certain field in a BEFORE INSERT trigger? [message #38747 is a reply to message #38746] Fri, 10 May 2002 08:02 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Yes, just assign the new value:

:new.column_name := 'some other value';

Report message to a moderator

Previous Topic: Re: create sql extention on notepad
Next Topic: Dates between two dates
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 22:28:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.