Newbie to triggers

From: <HLNG_at_USA.net>
Date: Tue, 18 May 1999 05:29:34 GMT
Message-ID: <7hqtrs$l8r$1@nnrp1.deja.com>

I'm new to Oracle, and would like to automate the following via a trigger whenever a record is inserted / updated:

Update po_lines_all
set item_description = rtrim(item_description) where length(item_description) - length(rtrim(item_description)) > 0 ;

Can someone advise on the required syntax and steps necessary to implement?

Thanks in advance.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue May 18 1999 - 00:29:34 CDT