Home » SQL & PL/SQL » SQL & PL/SQL » TRIGGER
TRIGGER [message #37856] Mon, 04 March 2002 03:10 Go to next message
SA
Messages: 37
Registered: March 2002
Member
hello,
i have a column "address".
i want to have a query in my trigger if "addresss" has been entered a value like 'USA' then select next.val from sequence s1.
i don't succeed how to do coding for it to sense that 'USA' has been entered.
thanku in adv.

Report message to a moderator

Re: TRIGGER [message #37858 is a reply to message #37856] Mon, 04 March 2002 03:18 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
if instr(:new.address,'USA')!=0 then
....
else
....
end if;

Report message to a moderator

Previous Topic: sql
Next Topic: Pleaseeeeeeeeeee help me, its quite urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:11:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.